Hello,
I have a problem with the drills.
I have the hierarchy Time wich have the attributes year,quarter, month and day.
I have two fact tables. My fact_table1 have month and my fact_table2 have day.
When I have a report with the fact_table1 and the attribute month and I try to do a drill to day it's giving me an error because it is not possible to do that.
How can I configure the hierarchy to say that when I have fact_table1 I cannot drill to day and when I have fact_table2 I can drill to day?
I want to do this because imagine that the users don't know all the model of the database, so I need to limit the access to drill to certain attributes when associated with certain fact tables.
Thanks.
I have a problem with the drills.
I have the hierarchy Time wich have the attributes year,quarter, month and day.
I have two fact tables. My fact_table1 have month and my fact_table2 have day.
When I have a report with the fact_table1 and the attribute month and I try to do a drill to day it's giving me an error because it is not possible to do that.
How can I configure the hierarchy to say that when I have fact_table1 I cannot drill to day and when I have fact_table2 I can drill to day?
I want to do this because imagine that the users don't know all the model of the database, so I need to limit the access to drill to certain attributes when associated with certain fact tables.
Thanks.