ssas - complex MDX query(s) -


i have cube following structure

1 measure sales count

three dimensions. brand, region, gender

i need mdx query(s) returns following 8 tuples.

  1. total sales across dimension attributes including unknown values
  2. the single highest value of combination of attribute values each dimension.
  3. total sales brand attribute identified stat 2
  4. total sales region attribute identified stat 2
  5. total sales gender attribute identified stat 2
  6. total sales brand attribute region attribute identified stat 2 gender attributes
  7. total sales region attribute gender attribute identified stat 2 brand attributes
  8. total sales brand attribute gender attribute identified stat 2 region attributes

your first query perhaps written using crossjoin show possible combinations of brand, region , gender:

select {    {[brand].defaultmember.children}*    {[region].defaultmember.children}*    {[gender].defaultmember.children} } on rows, {[measures].[sales count]} on columns [your_cube_name] 

does started?


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -