Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
Please find attachment.
Currently I am merging 2 QVW file into 1 QVW file.Though some of tables are same but it seems too complex.
It is also giving problem while opening newly created QVW file.So i am opening it by using without dataload option.
Can you please suggest what to do in this case.
Thanks,
Deepak
that is a complex data model! 1st thing i would do is to try building a star schema.
First of all you should try to denormalize this schema, you have a country table with just the CountryID and the Country you should consider adding it to the organization table directly by Country. You should do it with a lot of tables in your model because they are not adding any important data.
As less tables you have the easier to manage the schema.
I know that it is against to all the relational DB theory, but it is the best way to work with qlikview.