How to do sum of Dimension attributes with groups
-
Friday, February 15, 2013 4:34 AM
Hi Fellows,
My task is to show how many Work Order are OPEN or Closed based on First Grade and Second Grade.
To get the status of work order, I have a dimension attribute called as "Status", which hold any of the following values :
- COMP (-complete)
- WFCOMP (-waiting for complete)
- CLOSE (- close)
- OPEN (-open)
- INPRG (-In Progress)
Well, CLOSED work order will be the SUM (COMP+WFCOMP+CLOSE), and OPEN is SUM(OPEN+INPRG)
To get the grade I have another dimension attribute named as "Grades" which hold any of the following values :
- S-FG
- S-SG
I wanted to show the total of Closed and Open work order on my Y-axis and grades in X-axis. Could you help me to show what should be the approach / MDX code / Calculation formulas etc.
TIA.
All Replies
-
Friday, February 15, 2013 11:50 PM
Sorry, which information is in the fact table ?
Can you find this info in the cube by using the fact table combined with the status dimension ?
MVP MCT MCTS Daniel Calbimonte
http://elpaladintecnologico.blogspot.com -
Saturday, February 16, 2013 5:24 AM
Thanks Dani,
I resolved the issue with adding a Calculated Member in my Called as "OPENCLOSESTAT" in the dimension. This will hold either "Close" or "Open" basing on the value what "STATUS" is currently set to.
At one point of time, "OPENCLOSESTAT" will have either "Close" or "Open" values. I am using this value into my BI Charts / ScoreCards.
I found this solution based on my understanding, if anyone has got few suggestion please let me know.
Cheers!
- Marked As Answer by K. Feroz Sunday, February 17, 2013 8:53 AM
.png)
