MDX Formula for total of Hierarchy in ssas
$10-30 USD
ชำระเงินเมื่อจัดส่ง
Hi, I need MDX Formula for total of Hierarchy in ssas.
My current Measure is: [Measures].[Sales Qty]
when I display this measure in a matrix I need the total to be calculated on the following measure: [Measures].[Sales QTY FE]. The related Hierarchy is : Product. with 3 levels.
Product Name-> Product Family->Product Super Family
So when I am on a Product Family or Super Family I need the total to be summed using [Measures].[Sales QTY FE].
basically what I need:
QTY = sum([Sales QTY])
TOTAL QTY = sum([Sales QTY FE])
So I need someone to write the formula for me. and tell me how to past it in the cube as calculation etc...
หมายเลขโปรเจค: #15897501
เกี่ยวกับโปรเจกต์
มอบให้กับ:
I am having 6+ years of experience in MSBI (SSIS, SSRS and SSAS) with strong sql background. Worked with large data sizes.