Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Well, I'm in over my head.
I'm part of an integration project and am trying to dashboard without a data warehouse.
Loading various source files into Qlikview, my data model has the appearance of a synthetic main table being fed by various synthetic keys from my source files.
The more files I load, the more my reports stop working. So I know something is wrong here.
If anyone has had this problem, please let me know.
I feel one solution would be to load the files into a virtual fact table in qlikview - if this is possible any script example would be appreciated.
Just search here for "Synthetic Keys" and you'll get loads of advice!
For now I'm going to try concatenating most of these into one....
Just search here for "Synthetic Keys" and you'll get loads of advice!
Thanks Jason!
No problem. If you have what you need please mark a correct answer to close the thread.