cancel
Showing results for 
Search instead for 
Did you mean: 

no result with BWA

Former Member
0 Kudos

Hi All,

I need your help with the following situation:

I have an infocube 0xxx which one characteristic ZDIST and it is a referance object of 0customer.

Infocube is indexed in BWA:

If I display data from infocube by selecting ZDIST area it doesnt bring me any result.

However, if I display data from infocube and dont use BIA indexes I can get result by ZDIST.

I thought BWA indexes could be corrupted and rebuilt them, but it did not work.

And idea about the problem / solution ?

Best Rgards,

Berna

additional information..

I can display data from infocube with any area except ZDIST.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Berna,

Normally this should't happen unless you were in the middle of sending a transport with MD structural change or maybe running change run even that shouldn't impact..

So let's ask some questions maybe we can eliminate or reveal something else to help you

Do you have any user exit for ZDIST? or this cube or this query? If this query is on top of a multiporvider, can you just create a simple query on top of the base cube and run it with ZDIST from BWA to see if it's going to bring any data?

Can you run a query-from another cube- that has 0customer/ZDIST in it from BWA?

Can you see if 0customer is indexed from rsddbiamon2 > indexes?

Is ZDIST a compounded MD? If so is the compounded char in BWA? If so is the other part of the compounded char is a FLOAT type?

Did this just recently happened or was it always the case?

When you said you reloaded the cube - was the 0zcustomer reloaded from scratch as well or was it a shared MD therefore not re-indexed when you reloaded the cube?

Let's see you may need to use RSDDTREX_SINGLE_TABLE_INDEX or drop all the cubes if 0customer is shared and rebuild.

Cheers

Tansu

Former Member
0 Kudos

Selam Tansu,

With a simple query on the same MP result is the same .. no data.

There are infocubes which has ZDIST and where we get correct numbers.

All the compounding objects are indexed in BWA.

Hope deleting all the indexes and rebuilding will not be solution since we have more than 200 cubes indexed and have ZCUSTOMER.

Cheers,

Berna

Former Member
0 Kudos

Merhaba Berna,

So since it's shared across the system reloading the cube didn't re-create the 0customer index. And looks like it's not an option to reindex hundreds of cubes.

These are the things i would try before opening a message to SAP, some of them sounds unusual but your case is unusual as well

1) run rsrv check for the cube and MD

2) create a simple query on the base cube(not on the MP) and run with and w/o bwa

3) run the query from old gui and new gui - if you have this case

4) run the query without using variable for ZDIST - just enter as hardcoded

5) run full stats on the cube

6) lastly run the queries from rsrt in debug mode with and w/o bwa and check don't use cash box. Compare the stats, you will see obvious difference one will use BWA index one will use E&F tables, but you should also see some other differences, and let's look at them.

Goodluck

Tansu