TM1 Forum

Hi I found the answer. I am sharing it here just in case if anyone else is looking for the same. GENERATE( { TM1SubsetToSet([Dim-B] , "Product") }, FILTER( TM1SUBSETALL([Dim-A]) , [Dim-A].CURRENTMEMBER.NAME = [Entity].CURRENTMEMBER.NAME ) ) ) The mistake I made earlier was assuming that th...

Hi, I have two similar dimensions where the leaf level comprises shared elements. Lets call them Dim-A and Dim-B. Dim-A has a subset called 'product' . Using MDX I would like to create a subset in Dim-B by referencing the named subset of Dim-A. I understand this would require the Generate MDX functi...

Hi,

I understand in PAW we have the Action button configuration option to navigate from one page or book to another.
I am wondering if there is any trick to remember where I navigated from and return to the same sheet/page?
Just like a return or back button.

Regards,

Lav

Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases? Can you expand on how would you like to filter? Probably, which attributes are aliases, which are string attributes, which are numeric. Something like the DType or ElementType functions. Hi, I found one use case as follows F...

PavoGa wrote: ↑Tue Oct 03, 2023 1:42 pm Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases?

Can you expand on how would you like to filter?

I am on Planning Analytics on Cloud . I have prepared few training documents for users in html format(.html) and uploaded these to data directory folder on cloud drive(\\data\s\prod\...). I am wondering if Is there any way in PAW to access these html pages from data directory on cloud environment an...

Thanks Adam,

For you suggestion.
I am aware of this option to use picklist and draw your selection from the cube.

I was wondering if there is another faster and better option achieve the same because this is just a UI exercise.

Hi, I am wondering if there there is any option to programmatically know the current user selection on a cube viewer in PAW or TM1Web. I understand there is Drill option but drill would only capture the latest one element. Also there is keep option in PAW but there is no programmatic way to access t...

Thanks Declan,

This is great. I will tweak it a bit further to match some of my other filtering requirements.

But really helps.

Cheers,

Lav

Hi MDX experts, I am trying to generate a subset based on two hierarchy from same dimension. I am trying this in PAW. I have dimension Name 'Product'. This dimension has two hierarchies. 'Product' and 'Leaves' [/color] On 'Product' hierarchy I have subset name 'Engineering'. Now I would like to appl...

Hi Lav4you, I would imagine what is going on is something like this. You define view A which is contained in PAW screen B. User opens PAW screen B, at this point PAW screen B has a local copy of the view A which is the user is free manipulate and navigate subject to rights etc. You change the defin...

I'm guessing you're just changing dimension selections/subsets in the view and not trying to render a completely different cubeview right? You could use a parameters cube to store the mdx parameters and have the cube mdx reference that cube for dimensions selections within the query. Thanks ascheev...

Hi, In theory if I have a view created through MDX in server, I use this view on a book and then run a ti through action button in PAW to update view's mdx it must update my view based on TI in my book as per the new MDX supplied in TI. but in practice paw doesn't do that. The view remains static ti...

I tried the CellPutS but the trick didnt work.

gtonkin wrote: ↑Thu Feb 09, 2023 2:22 pm Think I had something similar and ended up adding this along with the HierarchyElementSecurityPut statements iirc:

Code: Select all

#--Give Access to see a particular hierarchy in the dimension
CellPutS(sElSecurity, '}DimensionSecurity', pDim | ':' | pHierarchy,  sGroup);

I will give it a try and let you know

MarenC wrote: ↑Thu Feb 09, 2023 1:20 pm Hi,

Do you have any cube or dimension security rules on the model?

Maren

No. no rule on any dimension or '}ElementSecurity' cube.

Hi I am facing a strange behaviour in PA. I update a security through TI for an alternative hierarchy. The process is very simple. It uses the following function to update security. HierarchyElementSecurityPut(sElSecurity, pDim, pHierarchy, sElName, sGroup) ; Elements for which I am update security ...

Thanks gtonkin.

Thanks Wim, I have done exactly that IIF and Count.

I got this idea from your website with amazing pool of MDX examples.

Thanks for that..


Regards,
Lav

Hi All, I would like perform a dynamic operation on a subset such that, IF FILTER MDX Expression returns empty subset then use different subset else use the same. IIF( ISEMTPY( FILTER(TM1SUBSETALL([Employee]) , [Employee].[State]) = "Active" ) , [Employee].MEMBER, FILTER(TM1SUBSETALL([Empl...

The Rule is simple

['Existing'] = S: IF (
DIMIX('Project', DB('User Input Check', 'New Project', 'String'))>0,
'Existing',
'New');


Further DImensionElementExist is a TI function not available for cube rules..