question

jlj76 avatar image
jlj76 asked

MDX LastNonEmpty aggregation issue

I have turned on LastNonEmpty aggregation on a facttable of valuations, and this works great when its just date and value. When I then try and display date and value broken down into dimensions ie by Individual or by Group, the totals are no longer match up with the first date and value totals. I have read this is due to the absence of a value in the period for certain dimension members. Is there any way to get around this other then ensuring there are 0 values in the fact table for the various dimensions? Regards Jon
mdxsumaggregation
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jon, could you provide a sample of what you're seeing vs. what you are expecting to see?
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.