Use IF ELSE statement

Yes ... your assumption is correct... MDX is used to extract data from cube as Tsql does for RDBMS... when you use excel as a reporting tool... excel generates xmla...

I have written one post on MDX interview questions. hope it will help you in covering different aspects of MDX:

http://www.msbiconcepts.com/2010/11/interview-questions-for-mdx-mdx.html

In Profiler, Query Begin and Query End Event Class will show you MDX in Text Data.

There are some good articles and MDX examples on Vidas site : http://www.ssas-info.com

specially MDX cheat sheets which will be very useful.

Use SQL Server profiler and connect to analysis services trace. You will get MDX code.

You need not to give full access to the cube. Read access will suffice. I have written one article on SSAS cell and dimension security. Let me know if you...

Look like fact has some dimension key for which record is not present in dimension table. I am not sure why it is not giving error in SSAS.

Try below...

I have not come across any standard tool for SSAS so far... but you can monitor performance in profiler by starting new trace and capturing related events. Mainly facts take...

You should be able to add user_count as integer in SSAS. Let me know the error. what is the data type of user_count in DSV?

I think data definition has changed in relational database or it is out of synch with DB ...please refresh database from Data source view DSV and then reprocess the cube.

It process the cube data based on silence interval defined in your cube.

http://www.msbiconcepts.com/2010/10/proactive-caching-sql-server-2008.html

This post triggered me to write new post on my blog :)... Please find link to the post below:

http://www.msbiconcepts.com/2010/10/proactive-caching-sql-server-2008.html

Hi Elham,

Proactive caching detects the changes and then process the cube automatically. If it is just for detecting changes then feature will not be useful.

Let me take your example,...

Open your solution and in data source view, right click and choose "refresh..." then solution will connect to data source and will reflect all the changes.

Hope i have answered...