MDX which takes Value from Cube

[EP_explorer]

Dimension Periods.
Jan, Feb, Mar, Apr

Cube A with 2 dimensions
dimension X (contains 1 element X1)
dimension Y (contains 1 element Y1)

In Cube A in put one value - Jan

How I can write MDX expression which return value from Cube A (Jan)
I tried something like
{[Periods].[Cube A.([X][X1],[Y].[Y1])]}
but without result.

Can you help me?

[declanr]

Code: Select all

{StrToMember("[Periods].[" + [CubeA].([Dim1].[Element1],[Dim2].[Element2],...) + "]" )}

[Edward Stuart]

Spend some time with the TM1 MDX Primer:

http://www.bihints.com/book/export/html/68

and the MDX Function Support section of the reference guide

https://www.ibm.com/support/knowledgece ... ort_N20006

It all comes down to what you are actually trying to do, return a value in the cube viewer? or via an external tool?

[EP_explorer]

Code: Select all

{StrToMember("[Periods].[" + [CubeA].([Dim1].[Element1],[Dim2].[Element2],...) + "]" )}

Thank you. it works.

[chalvax]

Spend some time with the TM1 MDX Primer:

http://www.bihints.com/book/export/html/68

and the MDX Function Support section of the reference guide

https://www.ibm.com/support/knowledgece ... ort_N20006

It all comes down to what you are actually trying to do, return a value in the cube viewer? or via an external tool?

Sorry but I have to comment on your answer, Mr. Stuart.
Luckily there are other users' who give a helpful, real and direct answer to the question of an user. I had the same problem like EP_Explorer. The simple case of a syntactic error. A missing double quote respectively the doublequote on the wrong position. So the answer of declaner worked. Your's sounds pretty - let's say - prejorative in just telling somebody something like "start learning mdx, we don't have time for such beginner's questions". I guess you pretty well knew, what the problem was! Well, but maybe I'm wrong, then I apologize for this appraisal. And by the way, the IBM Documentation is very often of little or no help! It just gives a listing of supported MDX commands without any examples how to use them! And by the way what did you mean by 'It all comes down to what you are actually trying to do, return a value in the cube viewer? or via an external tool?' What makes the difference?

[MarenC]

Sorry but I just had to comment on your comment Mr Chalvax,

What kind of arrogant fool would take issue at beginners being given a direct link to very useful help guides, which would further their knowledge, and set them on the path to self improvement and discovery, especially as the direct answer had already been given?

The useful help guides being the BI hints, not the IBM stuff, I will grant you that

Maren

[Edward Stuart]

Wim's excellent MDX reference guide:
https://www.wimgielis.com/tm1_mdxstatements_EN.htm

George's excellent MDX reference guide:
https://community.ibm.com/community/use ... 4eda43146b

Be part of the solution, not part of the problem

[lotsaram]

Why would a new user with no post history necromance a thread from 6 years ago just to troll someone? Very weird stuff. Maybe it's a chatbot/trollbot?

[MarenC]

If its a chatbox it passed my Turing test

[WilliamSmith]

Anyway... while we're here in 2023... using ChatGPT to help generate, as well as breakdown and understand MDX statements is invaluable. It also knows Turbo Integrator and rule/feeder syntax!

[Wim Gielis]

Anyway... while we're here in 2023... using ChatGPT to help generate, as well as breakdown and understand MDX statements is invaluable. It also knows Turbo Integrator and rule/feeder syntax!

Like the CubeNext function in TI

[WilliamSmith]

I guess the only gatekeeping now is to have functionality entirely undocumented! lol..

[Adam]

Why would a new user with no post history necromance a thread from 6 years ago just to troll someone? Very weird stuff. Maybe it's a chatbot/trollbot?

Was thinking the same thing.

Like the CubeNext function in TI

Did someone ask for me?