on 03-31-2015 12:38 PM
Hello Expert SAP BI,
I Extracting Data from Flat File,
Till then Cube My Transaction data Loaded Perfectly ,
i want to create Report in Bex Analyzer, fetching fields from Bex Query Designer.
Characteristics are showing in Rows , that showing in Report , but in Columns added Key Figure , its not showing in Report .
Can any one Suggest , what will be issue and how i have resolve it.
- Thank you.
Hi,
Can you goto query designer and open the query.
Goto column and click on keyfigure which is not displayed.
On the right side you can see the 'Properties".
Goto "Display" button under Properties and check under "Hide" whether "Always Hide" is checked.
If this is checked then that keyfigure which not be visible.
Make it "Always Show.
Regards,
Amit Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jatin,
Have you created report on Infocube or Multiprovider. if it is MP, did you do assignment of this KF properly. Are there any filters defined in query.
Regards,
Vengal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
At cube level are you able to see data for your key fig?
Cube loaded request have reporting symbol?
If then you can see data at reporting bex level also.
Can you share your bex designer screen shot.
Are you familiar with bex reports/creations.
Have any filters/conditions/variables?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Customer_mstr(is this info object or display attribute) -->what is this?
You created report on Multi provider.
Then how many targets connected to your multi provider?
Have you done proper identification(chars and key fig)?
if yes then lets try to see the data thru LISTCUBE, here you can provider multi proivder name and see the data.
this looks oke.
I suppose you didn't create additional ABAP logic in start- or end routines?
i would like to see your record counts from the logs.
Form PSA to DSO and from DSO to cube.
ANd if you would do a Display Data on the cube and just put checkmarks with the boxes for 'Use DB aggregation' and 'output number of hits'
then i would like to see the results....
Datasource -> Transformation -> InfoSource here defined Quan as Char
Infosource -> Transformation -> DSO - Here your defined Quan as Qty and length 17
First two stages you mapped to wrong fields(types) at transformations. make them correct and delete and reload whole data.
while doing mapping, check their technical things like type/length. they need to be same type/length.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.