TM1 Forum

Hello, As in the TI paste the MDX query in the subset, which is used in the view?
Thanks.

Hello, How to check for the presence of the element in the subset?
Thanks.

Hi,
When I do "reorder dimensions" last dimension contains string element, generates an error "Dimension Re-Order Failed". You do "reorder dimensions" last Dimension?
Thanks.

This is must reading for anyone first learning MDX....http://www.bihints.com/creating_dynamic_subsets_in_applix_tm1_with_mdx_a_primer Thanks Tomok,This is the updated MDX Primer link: http://www.pxbconsulting.com/downloads.html :) I read this book. there is no information how to accomplish my task

In my view one dimension is filtered based on a second. Okay triggered when the child dimension in view as row

Hello. I have a MDX query which filters one dimension [CAPEX OPEX Accounts] for the selected dimension item [CAPEX-OPEX]. When the dimension [CAPEX OPEX Accounts] in View as ViewRowDimension, the filtering works, but when ViewTitleDimension the MDX does not work? Tell me how to solve the problem? {T...

bogdan, To be able to use CurrentMember it has to have some context for that dimension; which either must be for that dimension you are filtering or via a query to another cube. The MDX you supplied is a dimensional MDX expression not an MDX query. You are also working with [Model] dimension so the...

I have cube "Measures" with dimensions ("Model", "OPEX cost centers", 'Business', 'Measures' ... etc) and cube 'Сost centers mapping 4' ("Model", "OPEX cost centers", "!y22") And that I had to select dimension 'OPEX cost centers' in cube 'M...

Hello, I create an MDX query that filters by the value of the cube, a dimension which we asked, but why it does not work? This query does not return result {Filter ({TM1SUBSETALL( [Model] )}, [cost centers mapping 4].(STRTOMEMBER('[OPEX cost centers].['+[OPEX cost centers].CurrentMember.Name+']'), [...

Hello! I have a dimension in which both text and numeric elements. I need for all text to execute the rule which will be the first. [] = S: IF(!Version @<> 'New', CONTINUE, STET); But then writes the error in the trace on the consolidated elements "RULE LINE ERROR" Tell me how to solve the...

I need to change the width dimension in the view

And with the help of functions "HIERARCHIZE" or "EXPAND" it is impossible to exclude the child elements?

How do I remove the select child elements ?

Filters for level 1, but an opportunity to expand the child elements. And what would need cannot be displayed.

What would I need to display only the elements of level 1 and it was not possible to choose the elements of level 0 .

I am having an dimension with the following structure

-aaa
| - a11
| - a12
| - a12
-bbb
| - b14
| - b21

I need what would happen

aaa
bbb

Architect

Hi, As in Turbo Integrator created a View and you can change the width dimension?

Many thanks

Hi, this is an MDX for TM1 subset create question.
We want display level 1 and remove level 0 rom the subset.

Many thanks