Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my QVW I load separate tables from different sources to build the star schema and keys.
Once I have the data in a star schema format I want to reduce the data by business line, so that when I build my dashboard, items the dimension tables that are not related to the business line are removed.
I also would like to know if I can exclude the grey items from the list boxes, I only need 100% associations.
Thanks
Tinkerz
Hello,
try File -> Reduce Data ->Keep possible values
Regards
Tinkerz, the only other idea I have would be to binary load the original file and then use resident load to only pull what you want and drop the other values that way, that would be more automated versus the other post, not sure what your requirements are here.
Cheers,
Brett