I Nav. I am using two key tables the Item ledger Entry and the item Value Entry tables. In the data-stage I use have calculated (lookup) fields in both tables, for example I calculate Cost from the Value Entry in the Item Ledger Entry, and calculate A Lot number from the Ledger Entry into the Value Entry. Both of these tables are used as fact tables in different Cubes. Currently I bring in the Value Entry ahead of the Item Ledger Entry. How can I then calculate values from the Item Entry into the value entry?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
If I understand you problem correctly, you would probably need to use a custom SQL step in the data manager on either your staging or data warehouse (Staging better) to run after your sources are pulled through but before your DWH is populated. I have not found a way to have the same tables populate first in one sequence and then in a second sequence in the same staging database.
Hope this helps a bit
Regards
Tom
Please sign in to leave a comment.