Help in Change request

[manu1512]

@hi,

Please see the picture below. ”BolagNr” is he company code. Each company code is connected to specific “CO_Object”, each “CO_Object” contains the field “Funktion”. So for example when you choose company code 0240 only a few “CO_Object” will be selectable and therefore only the “Funktion ”s that belongs to those “CO_Object.

Economy  uniper is final qvw and other one is qvw where transformation is taking place.

Can any one help me pls in this requirement ?? please its very urgent?

Thanks

Manu

[manu1512]

Hi ANIL,

where should i place this condition??

[Anil_Babu_Samineni]

in text box under layer tab of condition enable?

[manu1512]

Not working..........here we have to link column Co_Objekt and Funktion so that it filters Funktion according to selected Co_Objekt.

[manu1512]

stalwar1‌vishsaggi‌ any help please?

[vishsaggi]

Hey Manu, Sorry will look into it once i go to work.

Did you get a chance to work on the question i replied in my earlier responses like one below?

First you need to figure out how the data from Funktrion is linked to your fact tables values. How do you know which value from Funktion is linked to values from Co_Object.

[manu1512]

Hi Vish,

Every Company Code (Bolagnr) having a specific field "Funktion" in the Data Base and each co_objeckt is transformed  column formed from the Company Code .

Now we have to link Co-Objeckt with Funktion

[vishsaggi]

Ok I am looking into this now. Can you tell me where i can find this "Funktion" field in your data model i mean which table has this field?

[manu1512]

hi Vish,

If you can see the the script of other qvw ..qvd generatopr ..it is coming from this qvw..

[vishsaggi]

I can see that field in many places in you QVD generator tabs so are you pulling these QVDs in to your actual qvw file. Well i can see in your actual Qvw file you are not pulling the Field "Funktion" coz you are not using this field in your QVD load and in your resident load it is missing. Like see below images:

SO in your SAP Data tab you are pulling this Field and doing a left join to your Manuell table.

Then you are doing a resident load from Manuell table but did not include that Field Funktion in this resident load and you are deleting your table Manuell, that is where you can't find the field Funktion. So if you add all or relevant fields from Manuell table to this Data table you should able to see this field Funktion. Correct me if i am going off the track.

[manu1512]

Got it many thanks Vish.......will come back to you incase of any query