I'm new in Qlik world, I've been working with Oracle BI for years and it took me a while to get used to it. I have a problem with the star model, in Oracle BI I have a sales model with fact table of invoices (with daily sale) and the sales budget (with monthly budget); both fact tables have several dimensions in common; I am currently passing this model to Qlik and according this scenario I have two questions:
1) By relating the dimensions to their corresponding tables, Qlik builds a third object where he assembles the synthetic keys, so what I read in the forums would be fine since that is how qlik works, but there is a way to remove this object and relate the dimensions and the facts directly?
2) As I mentioned I have the daily sale and the monthly budget, each one is related to its respective time dimension, one at day level and another at month level, how can I do to have a single time dimension that groups day and month levels to stablish a relation with sales and budget fact tables?
2) Your Daily sale and monthly budget are having different granularity when it comes to date. One is daily data and the other monthly. You can solve this by creating a simple Master Calendar. The master Calendar script has already been shared by rupamjyotidas. Just use the same script and change the Date field name to your date field name wherever applicable.
.png "Former Employee"){kind=icon}