1

I have a case where i need to have a dimension based on measure value. example :

enter image description here

enter image description here

the fact table is linked to date dimension through DateID, and what i want to add is another dimension for Tier, but the problem is that there's no specific range for date selection and it can be whatever the user select on the date dimension.

I can't do it in data warehouse as the date range to calculate and group the amount into each tier is not predefined. So is it possible to create something like this?

enter image description here

the only way i can achieve close to this is using analysis cube but it'll only come out as row example : enter image description here

Thanks in advance.

  • I can't do it in data warehouse as the date range to calculate and group the amount into each tier is not predefined. > How is it calculated? – Tom V Mar 13 '18 at 8:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.