Cube processing confirmation?

[current1999]

Hi, After processing your ETL package which loads data into the cube, how do you ensure that your cube has been processed? Current

[Mycroft Holmes]

Surely the last step in your ETL package is to call the processing method of the cube! (seems obvious but I don't deal with cubes so I may be completely wrong).

Never underestimate the power of human stupidity RAH

[S Douglas]

current1999 wrote:

After processing your ETL package which loads data into the cube, how do you ensure that your cube has been processed?

Well it depends on what you are looking for in confirmation. 1: Confirmation of last successful processing 1.1: If the SQL Server agent is processing your cubes, then you can set the agent up to send out an email on completion. This will tell you if the process completed successfully or failed. The only caveat is if you run the job as a SQL Server Analysis command, then the agent wont know if the command failed or was successful. Just make sure to run your commands as a SSIS package and there wont be any issues. 1.2: In addition to agent notifications I use a modified version of the Microsoft SSAS example, AMO Display Object Names. I modified it to read the structure and send me an email with last processing date / times of the cubes and dimensions. Info: http://technet.microsoft.com/en-us/library/ms160876(SQL.90).aspx Had to remove some of the code as it contained company info in it, but here is the juxed of it

               try
                {
                    //--------------------------------------------------------------------------------
                    // For each database on the server, we'll display its name and other objects names.
                    //--------------------------------------------------------------------------------
                    foreach (Database db in server.Databases)
                    {
                        Console.WriteLine("{0}", db.Name);

                        // Display Dimensions
                        Console.WriteLine("\\tDimensions:");
                        foreach (Dimension dimension in db.Dimensions)
                            Console.WriteLine("\\t\\t{0}", dimension.Name);

                        // Display Cubes
                        Console.WriteLine("\\tCubes:");
                        foreach (Cube cube in db.Cubes)
                        {
                            Console.WriteLine("\\t\\t{0}", cube.Name);
                            
                            // Display Measure Groups
                            Console.WriteLine("\\t\\tMeasure Groups:");
                            foreach (MeasureGroup group in cube.MeasureGroups)
                            {/\*\*/