Forum Discussion
Super UserHow to divide semantic model for specific range of dates from OneLake ?
Hi jaryszek
Thanks for reaching out again.
in this case we can create self service BI Model with RLS/OLS as mentioned by v-pgoloju.
the data model may look like below:
- there will be one fact table which will have data at day level and another fact table at year/month level(based on your requirement ).
- Date dimension will be connected at day granularity to day fact table
- Date dimension will be connected at year/month granularity to year/month fact table.
- Other dimensions will be connected based on keys.
then you can design RLS/OLS.(in OLS you can create a role who will see day level fact table and another role who will see year/month level fact table)
Thanks & Regards,
Praful Potphode
Super UserOk what if i have 1 semantic model and want to change different date granularity?
How to model star schema to achive it?
And multiple semantic models --> i do not know if this is the best option to show different granularities based on the same report.
Super UserHi jaryszek
Thanks for reaching out again.
in this case we can create self service BI Model with RLS/OLS as mentioned by v-pgoloju.
the data model may look like below:
- there will be one fact table which will have data at day level and another fact table at year/month level(based on your requirement ).
- Date dimension will be connected at day granularity to day fact table
- Date dimension will be connected at year/month granularity to year/month fact table.
- Other dimensions will be connected based on keys.
then you can design RLS/OLS.(in OLS you can create a role who will see day level fact table and another role who will see year/month level fact table)
Thanks & Regards,
Praful Potphode