0

Jet Data Warehouse Issues

I have recently been heavily involved with Jet Data Manager.

I am having a particular problem where I am creating a fact table in the Data Warehouse by bringing in fields/information from other related tables in to one. Here is a case where I have Assembled Items that Consume Certain items in an assembly process. I have created joins and have therefore increased the number of lines per shift, the CF Numbers in the attachment. When I preview the information from within Jet, it gives me the desired results. But when I connect to the cube and I pull the fields to the relevant sections in the report , some information is missing. But when I also show all values from the filter section in excel , I see all the information that should be shown on the report. My expected results is to see when I generate report if to see and be able to group report by Shift No Item Assembled, BOM Items and their quantities.


Some urgent assistance will be greatly appreciated

2 comments

Please sign in to leave a comment.