Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

using mdx query Expand / Collapse
Author
Message
Posted Monday, April 29, 2013 2:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 126, Visits: 236
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.
Post #1447754
Posted Monday, April 29, 2013 2:26 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Today @ 6:17 AM
Points: 1,816, Visits: 3,465
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.
Post #1447768
Posted Tuesday, April 30, 2013 11:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
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 : 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
Post #1448314
Posted Thursday, May 2, 2013 12:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 126, Visits: 236
Thanks
Post #1448702
Posted Thursday, May 2, 2013 12:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:07 AM
Points: 126, Visits: 236
Thanks....
Post #1448703
Posted Friday, May 3, 2013 6:53 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:54 AM
Points: 815, Visits: 2,032
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.


Post #1449174
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse