Data Mode - Cubemember/value

[Darkzler]

Hi everyone,

I'm having an issue to get text values when using the Data Model and cube functions.

This is my data:

Shipment	Type	FromCountryCode	FromCity	FromPostCode	ToCountryCode	ToCity	ToPostCode	Typ	Sum of Payweight
Y	PLL	PL	Maluszow	11111	SE	Skara	33333	PC	525​
Z	IPL	IE	Cork	22222	SE	Torslanda	22222	PC	652​
X	CLL	GB	Sutton-In-Ashfield	33333	SE	Malmö	11111	GC	625​

To get the data value in "Sum of Payweight" my formula is: =CUBEVALUE("ThisWorkbookDataModel";$I2;J$1)

However, I want to only have 1 row where I enter the shipment (Y in this case) to see that "Type", "FromCountryCode" etc. updates automaticly based on what it says in "Shipment".
The formula for Type is: =CUBEMEMBER("ThisWorkbookDataModel";{"[Data].[Shipment].&[Y]"\"[Data].[Type].&[PLL]"})

But since I want the "Type" to be dynamic and change depending on what it says in shipment - how do I write this formula?

Edit: Should say "Data Model - Cubemember/value" in the topic but I couldn't change the topic.

 

[Anfinsen]

Hi Darkzler,
I am not an expert by any means, but wouldn't an IF statement do the trick?
For example, =IF(Shipment = BLah, do this, othewise do this? It all depends on how many variables there are within the "Shipment" Category? Knowing how many different shipment categories there are and what those translate to might help some of the folks here better answer this for you.
Here's to hoping you find a solution!

Cheers!

 

[Darkzler]

Hi, I'm afraid I don't know if that would be possible to integrate because the cube member is specified in the formula. I've scoured the forums and google but to no avail, the closest I've got is someone who mentioned that you have to make measures for it to be displayed but I lack knowledge on how to create that properly.

Thanks for replying tho, anyone else care to give it a try? Thanks in advance!