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 to get count of records in my fact table with MDX. Expand / Collapse
Author
Message
Posted Thursday, June 6, 2013 9:57 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:53 PM
Points: 143, Visits: 316

My Fact Table has columns as

IssueId StatusId DateId Points
1 1 20130101 10
1 2 20130102 10
1 3 20130104 10
2 1 20130101 22
3 1 20130102 5
3 2 20130103 5

I wanted to see how many total points I have, it shows me 62 instead of 37.

Can any one tell me how do I fix this.

I heard there is a concept called Semi-Additive and Non-Additive Measures but I don't find any information on how to do it in SSAS. If you can provide that either, I will be greatful.

Thanks in Advance.




Good Luck :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Post #1460779
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse