April 29, 2013 at 2:04 pm
When working with SSas after creating cube you see the data as measures and dimensions.But when does MDX comes in to picture?Can anyone tell me when and how to use MDX in SSAs.
April 29, 2013 at 2:26 pm
Assuming when saying 'seeing' you mean via a tool such as Excel. Excel generates MDX to query the cube. You can also use MDX statements within the cube itself (when designing) to create things like custom members. Think of it somewhat like MDX is to SSAS cube as TSQL is to SQL Server DB.
Steve.
April 30, 2013 at 11:59 pm
To add to the 1st reply above :
1) You should know the syntax of MDX also how does it work.
2) What are the functions in MDX ?
3) You should also know how the cube is modeled which your querying ? What are the hierarchies, attributes, relationships ?
For more info, check out : http://www.mdxquery.com
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
May 2, 2013 at 12:14 am
Thanks
May 2, 2013 at 12:15 am
Thanks....
May 3, 2013 at 6:53 am
I would add that MDX allows you to create metrics for the cube users that take the information farther. You use it to create metrics such as percentages (eg completion percentage) that summarize the information in useful ways for your business users. That's a simple example. Averages are another common example. More advanced examples include rolling averages. If you are going to get good with SSAS, you will need to get good at MDX. Unfortunately I know of no good book that just addresses MDX within the context of SSAS, but I've seen good chapters in books. They can give you an idea of what is possible.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply