Cube to Cube (via Transformation) incomplete data

[Former Member]

Dear all,

I am trying to write data from one cube to another cube via DTP (FULL). I didn't set any Filters but the DTP doesn't deliver any data before Fiscal Period 005.2008. When I create a query on the first (SOURCE Cube) Cube I am able to see data from 2006 to 2010 but when I look at the data in the Back end (Right click on Cube - Display Data) I am not able to see any data before 005.2008.

When looking at the requests I recognized that the data was compressed until the 16th of May 2008. Therefore I compressed the data until July 2008 to check whether the compression could be the reason for the missing data. Nevertheless I am still not able to see any data before 005.2008 no matter if I compress more data or not.

Do you have any ideas why I can see the data in the query but not in the cube?

Best regards

Stefan

[Former Member · Accepted solution]

Try to set filter when you load to Target cube and check whether you get data or not? Or Pick a Document number which is not compressed in a request & load that.Do you see data in E Table at all?

@AK

[Former Member]

Dear all,

thanks for your help. The problem is solved. I tried all given steps but unfortunately I was not able to see the data. So I activated the system in our development system and transported the Cube to our Productive system.

Now it works

Best regards

Stefan

[Former Member]

Hello Stefan,

what have you done after compressing data till july 2008? Load again in the target cube or just check data? It could be that there is a different use of the factview on using a query than on using transformation or update rules. What is your BW release?

Have you checked which data you can see by using the factview. Normally convention is /BIC/V<ICUBE>F.

Maybe note https://websmp130.sap-ag.de/sap%28bD1kZSZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=561961

helps. But as far as I see it is just for pre 7.x releases.

Best regards,

Peter

[Former Member]

Hi Stefan,

when u right click on the cube you get the option of maintain aggregates. Aggregates are small cubes built on cube. I am not sure whether aggregates are there on the cube or not. If there are aggregates and active then you can drop the aggregates and try to run the query to see if you can still get the info in the query output that was missing in the cube.

[Former Member]

Thank you all for your help.

There are 100000 records in the cube and I adjusted the output to 1.000.000 records.

In addition I am able to see all records in the E table.

Dear Amit,

could you please advice how I am able to check the aggregates and what to do once I checked the aggregates.

Regards

Stefan

[Former Member]

If data is present in the query, it must be present in the cube when displaying its content. Silly question but did you check the number of rows you are displaying in your cube? Default value is 200, try putting a huge number.

[Former Member]

hi Stefan,

have you checked the aggregates built on the cube. it may happen that the data is there in the aggregates and then the cube is compressed. Hence you are not getting the data in the cube but the query is picking them up from the aggregates.

[Former Member]

Dear all,

when I look at the E table, I can see the data, but when I try to extract all data there is no data before the mentioned FiscPer

regards

Stefan

[Former Member]

Hello M.

I thought about this as well, but I built the query on the cube itself.

[Former Member]

Hello Srinivas,

I checked all selections but even when I do not make any selection at all and want to see all data (~1.000.000 data records) the data starts with Fiscper 005.2008

There must be something else I don't see.

Regards

Stefan

[former_member186445]

maybe the query is based on a multicube...and the data prior to 005.2008 is perhaps stored in another cube than the one you're looking at...

M.

[Former Member]

It's silly , but make sure you have given right selections for the right time(ex.001.2008 to 005.2008) char to display data for source cube.

Cube to cube - check the transformations if it has any start routine which deletes data before 005.2008