cancel
Showing results for 
Search instead for 
Did you mean: 

Quantity is Showing Blank : Bex Analyzer, Source - Bex Query Designer

former_member589680
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member589680
Participant
0 Kudos

It is in Show Mode only,.

former_member186053
Active Contributor
0 Kudos

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.

former_member589680
Participant
0 Kudos

I am Creating Report from Multiprovider,

I didn't used any Variables to do filters.

i want to show simply output.

RamanKorrapati
Active Contributor
0 Kudos

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

former_member589680
Participant
0 Kudos

Sorry for Cross Post, it was Due to Bad Internet Connectivity .

Here

I attached Screenshot ..

RamanKorrapati
Active Contributor
0 Kudos

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.

former_member589680
Participant
0 Kudos

Customer_Mstr is InfoObject and below Display attributes.

> Yes , I did Proper Identification while creating Info object in KeyFigure.

Last Suggestion point , i Couldn't understand thru LISTCUBE . ??

RamanKorrapati
Active Contributor
0 Kudos

T code - LISTCUBE, try to display your multi provider data.

That may give clear idea. Whether problem at MP level or Bex level.

former_member589680
Participant
0 Kudos

I am Sharing you my ScreenShot for confirmation.

All Characteristics Data are coming properly , There is no Data in "UNIT" else no any Keyfigure field .

RamanKorrapati
Active Contributor
0 Kudos

Quantity is at cube level along with units?

Are you new to bw and practicing?

Under your multiproivder how many targets are connected?

Former Member
0 Kudos

is the keyfigure connected in your dataflow?

former_member589680
Participant
0 Kudos

Yes , Raman Sir,

I am new in BW and doing Practice.

And Under multiprovider i have only 1 Target Infocube.

- Thank you for your Support.

RamanKorrapati
Active Contributor
0 Kudos

first check at cube level. Are you able to see data with customer and quantity/units.

RSA!, cube-->rigth click-->manage-->request tab, see here reporting symbol exist or not for loaded rquest.

former_member589680
Participant
0 Kudos

Yes, Request is coming Showing.

RamanKorrapati
Active Contributor
0 Kudos

Good. cube-->rigth click-->display data.

Select all chars for selection and see the data(quantity and units also)

former_member589680
Participant
0 Kudos

Yes, my Keyfigure is Connected with dataflow :

Former Member
0 Kudos

i see a value in your datasource (i think ) but not if this value flows into your cube....

former_member589680
Participant
0 Kudos

I can not find any Quantity Fiels , only UNIT is available , that showing Blank.

former_member589680
Participant
0 Kudos

Yes , in infocube Value is not Coming. ..

How may i solve this ?

Former Member
0 Kudos

you have to connect the right fields .

can you give us screenshots from transformation to infosource and from infosource to cube?

former_member589680
Participant
0 Kudos

I Selected all ,

Custer_mstr and KeyFigure (Quantity) both Fields are Blank ,

RamanKorrapati
Active Contributor
0 Kudos

leave bex report.

please check data flow and do the proper mappings.

later load data and check it.

First check your data flow/mappings.

former_member589680
Participant
0 Kudos

Datasource -> Transformation -> InfoSource

Infosource -> Transformation -> DSO

DSO -> Transformation -> Cube

former_member589680
Participant
0 Kudos

ok , I will Check my Data Mapping .

Former Member
0 Kudos

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....

former_member589680
Participant
0 Kudos

No , i Didn't Created Start-End Routines.

please let me know where i have to do changes

Former Member
0 Kudos

Now we have to check the data Could you please 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....

former_member589680
Participant
0 Kudos

Here , i Attached my Screen shot.

RamanKorrapati
Active Contributor
0 Kudos

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.