Skip to main content
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Reducing data after loading seperate data tables


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.








2 Replies
Partner - Specialist
Partner - Specialist


try File -> Reduce Data ->Keep possible values



Former Employee
Former Employee

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.  


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.