Analytics Software

Hi,

I have noticed a strange behaviour related to data loads and data visibility through the Financials Analytics dashboards.

Let me please begin with an empty target schema.

I run the first load having the General Ledger subject area (Full Load=Y). When it's successfully completed, I can see data in most of the tabs of the GL dashboard. In the Profitability dashboard, I can see P&L statement with data.

However, when I run further loads for other subject areas like - paybales, receivables, revenue, cost of goods sold, supply chain, etc., I see, gradually, empty GL dashboard across its tabs. I can not see the P&L statement with data, too.

I take an export of the schema at the end of each load and create a log for each of the export. I compare the logs and can conclude that there is no loss of data (W_GL_OTHER_F) because of, may be, the next loads that I usually do. There is no data in W_TAX_XACT_F from the first load. I notice that due to the next loads more tables are populated with data or the tables with the data have more rows. So, there is no reduced number of rows in the tables because of the next loads.

When I 'modify' the reports in BI Answers by removing all the filters, I see no data, there, too.

Does anyone have an idea what the is the issue here? Am I looking at the right database tables?

Please let me know.

Thanks and regards,

Manoj.

Edited by: mandix on Oct 8, 2008 4:48 AM