cancel
Showing results for 
Search instead for 
Did you mean: 

Query doesnu00B4t have any data.

Former Member
0 Kudos

I have modified the structure of the infocube 0SD_C03,

i when i import all the data again, i verified that the data is in the infocube fact table, but when i run any query, there is no data!!

Can somebody help me?

thanks

António Oliveira

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Have you deleted all the yellow and red requests posted before your current data load ?

Former Member
0 Kudos

I HAVE CANCELED ONE JOB FOR THE UPDATE WITH THE 2LIS_11_VAITM BUT I HAVE RUN AGAIN ANOTHER JOB AND IT WORKS WELL.

IF THE PROBLEM IS THIS UNFINISHED JOB, HOW CAN I DELETE HIM?

klaus_werner
Active Participant
0 Kudos

Go to Admin Workbench (RSA1), locate InfoCube, right mouse, manage and have a look at the request. There is a symbol that displays whether a request is available for reporting.

Delete red requests with delete button.

Regards, Klaus

Former Member
0 Kudos

Thanks, i have no idea that this red request have to be deleted...

Former Member
0 Kudos

Hi António,

if your wrong request is still in yellow, you have to force the traffic-light in red and then delete it !

Bye,

Roberto

(and please don't forget to assign some points to the contributors that helped you !!!)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

Be sure that no prior load is in the cube with error's (yellow or red in the monitor).

Do You use aggregates - if so make sure that the data loaded has been rolled up in the aggregate.

Regards

/Frank