cancel
Showing results for 
Search instead for 
Did you mean: 

infocube doesn't shows the data

Former Member
0 Kudos

Hi,

I have Created Z Infocube in BI 7.O.but actually Fact Table shows the data and Infocube Content doesn't Shows data and also Query also shows data. why? i can't able to find the solution?

Now i have ready to move DEV to QAS.

Thanks

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

ANSWERED

Former Member
0 Kudos

Hi....

Do you mean to say that the query is also showing data ?

If so then the cube must also have the data because the query is based on the same cube......

Try with the tcode LISTCUBE........though both are same but still try............

when you will execute a message will come "InfoProvider contains too many characteristics;make a preselection"..............are you getting this screen...........have you cecked the Characteristics here which you want to get displkayed in the output ?

Look I don't what are the characteristics............but if the value of those Chars is blank then the there will be no output........

Select the characteristics which are used in the Query.......and then execute with the same query selection.......

Regards,

Debjani...

Former Member
0 Kudos

Hi,

Thank you .solved my problem.

Devi

former_member182516
Active Contributor
0 Kudos

Hi Devi,

In the manage screen what is the status of the requestes loaded to IC.

Are you sure you had selected the option "charateristics for output selection".

before selecting the contents -->select the table --> select the above option n select all the fields for output and execute it should display the data.

It can't be authorization problem bcoz devi is able to check the data in fact table and also data in the report.

Regards

KP

Former Member
0 Kudos

Hi Devi,

While you are selecting the Characteristics after you click on "Contents", Select the characteristics for which you are getting data in query.

This may be the issue that the fact table doesn't have the data with the combination of characteristics that you have chosen.

Hope this helps, correct me if i am wrong.

Regards,

Venkatesh.

Former Member
0 Kudos

As said by sarmah,you might not selct the charactersitics for output selection.

else if you had selecetd ,

when you get the empty screen in the out put,

Click on chagne layout and the pull all the chars from right to left side.and press enter.

hope this helps you....

Former Member
0 Kudos

While checking the content of the infocube, please check if you have any filter selected and also make sure you have selected the required characteristics and KFs in the selection screen.

Former Member
0 Kudos

Hi,

I have already checked no filters

Former Member
0 Kudos

hi,

Do you have the authorization to see the data for the cube. If data is there in dimension table and not visible in contents then it is an authorization issue in most cases.

regards,

Arvind,