cancel
Showing results for 
Search instead for 
Did you mean: 

InfoCube QM Status=Green before Reporting on BPS Cube

Former Member
0 Kudos

Matez,

As I understand, that an InfoCube needs to have it`s QM status to be =Green, before any query can be executed on the Info Cube.

So, for BPS Cubes, as I understand that the QM Status will only turn Green once, 50000 records has been written .

Please advice if I`m able to report on the BPS INfoCube while the Status QM = Yellow

Thanking in advance !

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Take a look on the note :382744

With rgds,

Anil Kumar Sharma .P

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi John,

You can do the same by including the characteristic

Request ID 0REQUID with the variable

Most Current Data 0S_RQMRC

in the BEx query/report.

Include the variable in the report and you would be able to see the data even if the request is in yellow state.

Cheers

Anurag

Former Member
0 Kudos

As Anurag mentions, for queries that need to pick up the most recent information from an open (yellow) Request, you need to include the Most Recent Data variable.

As I recall, what happens is there is one database query the reads the open request and another that reads the rest of the fact table ( or two if you have compressed some of the Requests into the E fact table.

If you have an aggregate created on the transaction cube, the BW is smart enough to go get the data from the open Request and then get the rest of the data from the aggregate.