on 07-07-2011 10:21 AM
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
ANSWERED
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.