TM1 Forum

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?

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?

declanr wrote: ↑Wed Jul 19, 2017 2:19 pm

Code: Select all

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

Thank you. it works.

Edward Stuart wrote: ↑Wed Jul 19, 2017 2:26 pm 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?

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

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

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?

If its a chatbox it passed my Turing test

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!

WilliamSmith wrote: ↑Wed Sep 06, 2023 3:43 pm 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

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

lotsaram wrote: ↑Wed Sep 06, 2023 11:07 am 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.

Wim Gielis wrote: ↑Wed Sep 06, 2023 4:10 pm
Like the CubeNext function in TI

Did someone ask for me?