Hi everyone
It is a pleasure to greet you, I am trying to add the direct access dimensions of nav as a dimension for the accounts receivable cube but I do not find the correct way to perform this process I also have the difficulty that the information of the dimension set entry and dimension value the records are duplicated, could someone help me how to create these dimensions in the best way for the cube
Thank you very much in advance
Best regards
Hello Jorge,
I did not quite understand what you are trying to achieve. However, integrating and connecting the dimension set entries is possible like this (there are probably other possible ways to achieve this):
First, you need the dimension set entry table with the fields "DW_Account" (SPK), "Dimension Code" (SPK), "Dimension Set ID" (SPK) and "Dimension Value Code"; (SPK = Shared Primary Key).
Then you need to find all tables that you want this information to be available for. For the receivables cube -> Receivables Transactions (fact table), this would be the Detailed Customer Ledger Entry table. Many tables contain a field called "Dimension Set ID", which can be connected to the Dimension Set Entry table. This table (Detailed Cust. Ledg. Entry) does not. However, many fields originally were taken from the Cust. Ledg. Entry Table. Checking out that table will be successful. You want to join that field into the Detailed Cust. Ledg. Entry table and then take it to the Receivables Transactions table in the data warehouse section.
For each dimension you want to be available in the cubes from the dimension set entry, I created an individual table in the data warehouse and thus, an individual dimension in the cubes. Each table created here needs to have a filter on the desired dimension code. For example (showing two of the dimensions from the dimension set entry as tables in the data warehouse):
Within the cubes section, of course you need to configure the dimension relations. You only need to connect Dimension Set ID from the fact table to the one from the dimension (and [Dimension IC].[DW_Account] = [Receivables Transactions].[DW_Account] or "Company", depending on your naming, if needed).
The Dimension Value Code is the field you want to add as a dimension level to your "Dimension IC" (e.g.) as the visible field for the end user to be able to view and filter on. Other fields can be added, if needed.
Let me know, if this helps.
Best regards,
Johannes Herlitzius
