Hi,
Above are samples of two tables for a Banking Co., Table1 shows transactions of Customer X and Y. Table 2 shows due dates for each customer.
I want to find out balance as on due dates (table2) for each customer (sample: Table3) from Cube itself.
Pl Help.
Hello Suman,
I don't quite understand your setup. Is the data shown coming from the cubes already? Table 1 and table 2 should be possible by default already (of course selecting the receivables cube as a data source). Table 3, or Result, should be then possible as well.
If you care about the pivot table (I guess all three tables are pivot tables) to show each dimension in a separate column you can try playing around with the Report Layout. This is a function in excel in the Design tab (more information here).
If your challenge resides in the report layout regarding the date dimension, you can add the due date dimension to the rows and via right click on any date in the pivot table select Show/Hide fields to hide fields like Year, Month, or Quarter, as shown in the picture I attached for you.
Best Regards
Hi Johannes,
Table 1 and Table 2 are Tables in Data Warehouse while I need Table 3 from Cube (Result on Pivot Table). Report should have dates only of Table2 (Due Dates) Customer wise and the balance as on date (Of table2) for each customers.
Hi Suman,
So are you asking for help to set this up in the cubes or do you need help to build a report in Excel? If table 1 and 2 are already available in the data warehouse, it is very likely that it is also available from the cubes. As I mentioned above, working with the Receivables Cube, this should already be possible by default. I still don't understand what you try to do. If you can't give me more detailed information, I probably cannot help you. Maybe someone else can...
Best Regards
Hello Suman -
Just as Johannes stated, if that information is in the Data Warehouse, it should also be in the Cubes.
You may want to meet with a Jet trainer to see if, together, you can figure out how to do what it is you need. If there is information that is not in the cubes or the JDM project, a Jet project consultant could do that for you.