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.
