How to handle a navigational attribute in Query designer, which is actually a compunded with other info object.

[sudhir_vanap]

The scenario is:

This is about Inventory report where the business wants to see data based on profit center & business code.

this is how initially it looks.

If they are drilling down in the report with profit center, controlling area also comes along with it (as 0CO_AREA is compounded with 0profit_ctr)

the value CHAU.......

Now the Issue is we are getting # vlaues for business code for alrge volume of data in report.

We dont want that to happen.

When I check this profit center in master data table, there are tow entries....

the one with blank controlling area is creating the problem.

I have tried by adding the 0CO_AREA in the rows in query designer and made it as 'No display'. but the Issue still persists.

Please help me here for avoiding that # values for business code and also the key figures should not get Impacted.

[former_member209202]

Hi Sudhir,
First check if the load dependency is correct or not. You should load your master data first then Transcational data.

Secondly, if profit centre has two data source, check if both the data source having CO_AREA or not, I assume that one of the data source is not providing CO-AREA which is why it is blank. In that case you need to talk to business to understand what should be CO-AREAs from that data source, if it is not coming from Source system, so that you can code it out in transformation. Functionally, a profit centre is not valid with out a CO-AREA.

As Akanksha has mentioned, please use a query key date in case the profit centre is time dependent.

As a last option if you satisfied with the result of of the report with all the rows where Controlling area is not blank, put a global filter on CO_AREA in you query.

Hope this helps.

Regards

Sourav

[former_member185132]

Please check your transaction data. Looks like CO_AREA is not getting populated in the transaction dataflow. Due to that, during SID creation, it creates a record in the P table having blank CO_AREA.

The tx data flow will have to be fixed to correct this.

[KodandaPani_KV]

Hi,

have you updated the master data menas performed the attr change run?

extract the one more time all extract specfic profit center master data then perform the attr change run. - may it will avild the unassined values.

run the query in the RSRT or BEx analyzer.

-Phani.

[former_member186053]

Hi,

First you need to check why profit ceter has two enteries, did any one make manual entry with blank record. Check the master data load for this profit center.

And also can you bring the stock type and see what is the stock type for 2nd record in your screen shot. Are you getting transaction data from single source system or more.

Thanks,

Vengal.

[sudhir_vanap]

This 0profit_ctr is time dependent info object....im checking with that why multiple entries are coming for single profit center...also yes, this profit center is getting loaded from diff source systems

[former_member214274]

Hi,

Since the Profit center is time dependent-it will create 2 entries- one from 01.01.1000 to date entered and other from date entered to 31.12.9999

In your query-give some key date to avoid # values.

Query properties-Key date

Thanks,

Akanksha

[former_member214274]

Hi,

Even if there is a compounding infoobject, you should not get 2 entries (one CHAU and other blank) in the profit center master data table.

Please check why there are 2 entries-have you made profit center master data as time dependent?

Thanks,

Akanksha

[RamanKorrapati]

I have tried by adding the 0CO_AREA in the rows in query designer and made it as 'No display'?

if you made that then it won't shows co area as well.

Means while lets try again to hide compounded object and see the final output.

There is document which is created by me. get from google search and follow it.

please use search key as "How to Hide Compounding object from bex display".