Grand Total will always show the full total in SSAS


  • Hi,

    When I implement Many-to-Many relationship every time grand total is equal to the full total.

    Please find the attached image that shows clear idea.

    How can I resolve this issue. Please suggest me.

    Thanks & Regards Rajeee

    Sunday, September 29, 2013 11:20 AM

All replies

  • Hi ,

    Do you have any calculation regard to that dimension ? by levels or attributes ? if so, try the dynamic set fot the 'All' member . Otherwise, can you share some details about the fact/dim from the granularity and relations aspect ?

    Regards, David .

    Sunday, September 29, 2013 3:20 PM
  • Hi David, We do not have any calculation. We have only direct measure which device count. I have Fan redundancy dimension and Server Fact table. Between these We have many to many relationship. How can I create dynamic set. If you don't mind please give me a example.

    Thanks & Regards Rajeee

    • Edited by Rajesh.Ch Monday, September 30, 2013 3:14 AM
    Monday, September 30, 2013 3:13 AM
  • Hi ,

    Please refer to the next (great !!) link of Mosha's about the Dynamic sets :

    Just a simple syntax example :

    Create DYNAMIC set CURRENTCUBE.[DynamicSet]
    As{Filter([Dim Fan].[Fan_Hir].[Fan Items].members,[Dim Fan].[Fan_Hir].CURRENTMEMBER)};

    scope([Measures].[Actual],[Dim Fan].[Fan_Hir].[All]);
    this=  Sum(EXISTS([Dim Fan].[Fan_Hir].CURRENTMEMBER.children,DynamicSet),[Measures].[Actual]);
    end scope;

    Hope it helps :)

    Regards, David .

    Monday, September 30, 2013 5:51 AM