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

How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation? Expand / Collapse
Author
Message
Posted Sunday, September 15, 2013 7:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 1:56 PM
Points: 4, Visits: 13

I have in the underlying database a column computed from other values in the same row.

In ssas all these columns are automatically summed to provide the subtotals as I drill down hierarchies.

However, rather than summing the computed column values I need to perform the computation again in ssas using the subtotals of the other summed columns.

I am new to ssas but I have a sense that this is probably a common problem with a generic answer but I cannot find an example of how to do this.
Post #1494881
Posted Monday, September 16, 2013 5:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:23 AM
Points: 243, Visits: 2,722
I think an example of what you are trying to accomplish may help. However, based on what you noted so far, you may be able to look at creating a calculated member to sum your two values. SSAS does not handle aggregates of aggregates in a straight forward method.
Post #1495022
Posted Monday, September 16, 2013 7:14 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 @ 9:35 AM
Points: 818, Visits: 2,074
More information is needed to see what you are doing. A picture of what you currently see would also be helpful.


Post #1495064
Posted Wednesday, September 25, 2013 12:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 1:56 PM
Points: 4, Visits: 13
The solution was a calculated member - I realised this is what they are for!
Post #1498532
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse