question

PaulMauriello-5424 avatar image
0 Votes"
PaulMauriello-5424 asked CarrinWu-MSFT edited

How do I use MDX using an Invoice Age to correlate to 5 fixed Aging Buckets to then use as Dimesion slice on the balance?

How do I use MDX using an Invoice Age to correlate to 5 fixed Aging Buckets to then use as Dimesion slice on the balance?

This is as far as I got but i know its wrong. Instead of having an Balance column i want to split across the bucket?

115139-image.png


sql-server-analysis-services
image.png (46.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PaulMauriello-5424, we have not received a reply from you, any update for this case?

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @PaulMauriello-5424,

Welcome to Microsoft Q&A!

Please refer to below links:

Assign bucket types dynamically with MDX and dynamic sets in Analysis Services
How to create buckets on measures from 2 fact tables, i.e variance between actual and budget coming from separate fact tables


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.