Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hyukevain
Yak Posting Veteran
66 Posts |
 Posted - 2004-07-29 : 05:10:59
|
| Hello,I built a cube with many dimension. One of the dimension is Product that have Header and Detail Level.Because I already aggregated data in staging, and the header data already join with the detail so the aggregated count are multiple by how many detail that the header have.Now, I want to make a calculate member which can show the real Header total without aggregated by detail total per Header.Each header may have different detail amount, and the header count total only will show up in header level only.Can anybody help me to make the MDX query ? I really need an example for this case.Regards,Mike |
|
|
|
|
|
Calculate Member