No Reporting Symbol for the cube.

[Former Member]

Hi all,

no reporting symbol for an cube.

I created Z cube without any aggregates and loaded data sucessfuly QM status is green but i'm not able to see the reporting symbol next the request id. When i checked in manage content data, data is available for the fact but not for any dimension table.

Please go through the following when we did the diagnosis.

Diagnosis

There is an inconsistency between the load status of the data and the

option of reporting on this data.

There is data in the InfoProvider that is OK from a quality point of

view, but is not yet displayed in reporting.

The problem, for example, is to do with request 0000003343, number

REQU_44ROL5YBBCJMDL5HQ8TVBAER6.

Procedure

Choose Refresh to remove the inconsistency.

As per the procedure we did but went to short dump

UNCAUGHT_EXCEPTION

CX_SDB_ORA_PROGRAM_ERROR

Highly appreciable if any one could resolve our issues.

Thanks in Advance.

[RenjithKumar]

Hi ,

If there is any request with Yellow status / Red status , Delete that Also From Info cube - > Manage .

[Former Member]

Hi Dinesh , there is no Error request before this request ...

[Former Member]

Hi Niyati,

Is there any error request before this request. If yes, then delete that and check. If no, then retry the load from the PSA.

Bye

Dinesh

[Former Member]

Hi, Dinesh i have already checked the RSRV ...

[Former Member]

Hi Niyati,

What is your BW version. If it is BI 7.0 then check these OSS Notes:

975948 No update statistics for newly created tables

998904 Statistics check shows red or yellow traffic lights

If it BW 3.X version then run the RSRV check for the cube.

Bye

Dinesh

[Former Member]

Hi, Can anybody help me out .

[Former Member]

Delete the request, load the master data first and try reloading the cube.

Ravi Thothadri