Destination App (Script) - feasibility in a specific scenario

[vsreeja]

Dear all,

Please help on the below scenario,

Model A				Model B
Dim 1				Dim 1
Dim 2				Dim 2
Dim 3				Dim 3
				Dim 4
Dim 3	Property:DIM4			Dim 4
Chennai	Tamil Nadu			Tamil Nadu
Trivandrum	Kerala			Kerala
Dim 3 has a property "DIM4" where the members of Dim 4  are mapped.
Transaction Data
Dim 1	Dim 2	Dim 3	Sign Data
Sales	Jan	Chennai	50
Sales	Jan	Coimbatore	60
To be moved in the below combination in Model B
Dim 1	Dim 2	Dim 3	Dim 4	Sign Data
Sales	Jan	Chennai	DIM4 Property: Tamil Nadu	50
Sales	Jan	Trivandrum	DIM4 Property: Kerala	60
In a destination app script, we want to have the *ADD DIM part to be dynamic with the Dim 4 value changing as per the Dim 3 value.
Is this possible in DESTINATION APP.? We are trying to avoid a BADI in this scenario.
Or is it possible to LOOKUP this data from the Destination model and store them??

Regards,

Sreeja V

[former_member186338 · Accepted solution]

Yes, it's possible in BPC 10 with some not very old SP.

Just read official help for DESTINATION_APP:

*ADD_DIM P_DATASRC=INPUT, MARKET = PRODUCT:MARKET

MARKET is a property of PRODUCT dimension of source cube

Vadim

[vsreeja · Accepted solution]

Thanks Vadim. It worked.!!!

Regards,

Sreeja V

[Former Member · Accepted solution]

Hi Vadim,

Please help on the below scenario which is a reverse set up when compared to the scenario posted by Sreeja. I want to find the ID of the destination dimension which has a source dimension's member as a property.

Model A	Model B
Dim 1	Dim 1
Dim 2	Dim 2
Dim 3	Dim 3
	Dim 4
Dim 3	Dim 4	Property:DIM3
Chennai	Tamil Nadu	Chennai
Trivandrum	Kerala	Trivandrum
Dim 4 has a property "DIM3" where the members of Dim 3  are mapped.
Transaction Data
Dim 1	Dim 2	Dim 3	Sign Data
Sales	Jan	Chennai	50
Sales	Jan	Coimbatore	60
To be moved in the below combination in Model B
Dim 1	Dim 2	Dim 3	Dim 4	Sign Data
Sales	Jan	Chennai	DIM3 Property: Chennai   =Tamil Nadu	50
Sales	Jan	Trivandrum	DIM3 Property: Trivandrum  = Kerala	60

Regards,

Deepika G S

[former_member186338 · Accepted solution]

Hi Deepika,

Please open a new discussion and present the data in more readable way - Excel screenshot will be better.

Also explain from what model you want to write data into another model?

Vadim

[former_member186338 · Accepted solution]

P.S. In general, what you are asking is wrong!

You can loop target model with *WHEN_REF_DATA=MASTER_DATA and with *LOOKUP MODELA *DIM DIM3=DIM4.DIM3

But it is slow...