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
-
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts Hello -
For urgent questions, I would definitely suggest contacting Jet Report Technical Support (https://support.jetreports.com/)
My guess (and it is just a guess) is that the fact table isn’t modeled correctly. Each row in the fact table should represent a fact, usually this is going to be at the line level of detail. I am not sure what you mean by some information is missing, but my first guess is that there are rows in the fact table without associated facts, and these aren’t going to be displayed in a cube. Also keep in mind that you will need to have separate dimension tables to support your model.
I hope that helps. The support analysts for Jet Enterprise should be able to provide more-detailed help, if needed.