Search found 51 matches
- Sat Apr 13, 2024 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to create subset using subset from another dimension
- Replies: 1
- Views: 312
Re: MDX to create subset using subset from another dimension
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...
- Sat Apr 13, 2024 11:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to create subset using subset from another dimension
- Replies: 1
- Views: 312
MDX to create subset using subset from another dimension
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...
- Mon Apr 08, 2024 8:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Action Button Navigation
- Replies: 1
- Views: 277
PAW Action Button Navigation
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
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
- Fri Oct 20, 2023 4:51 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 17175
Re: MDX - Intrinsic Members
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...
- Wed Oct 18, 2023 6:54 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 17175
- Thu Oct 05, 2023 6:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to access html pages from data directory on PAW Cloud?
- Replies: 0
- Views: 11311
How to access html pages from data directory on PAW Cloud?
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...
- Fri Jun 30, 2023 11:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Check current user selection in UI
- Replies: 2
- Views: 686
Re: Check current user selection in UI
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.
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.
- Thu Jun 29, 2023 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Check current user selection in UI
- Replies: 2
- Views: 686
Check current user selection in UI
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...
- Sun Mar 12, 2023 6:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - How to use subset from one hierarchy to filter and generate subset on another hierarchy
- Replies: 2
- Views: 869
Re: MDX - How to use subset from one hierarchy to filter and generate subset on another hierarchy
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
This is great. I will tweak it a bit further to match some of my other filtering requirements.
But really helps.
Cheers,
Lav
- Sun Mar 12, 2023 5:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - How to use subset from one hierarchy to filter and generate subset on another hierarchy
- Replies: 2
- Views: 869
MDX - How to use subset from one hierarchy to filter and generate subset on another hierarchy
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...
- Thu Mar 02, 2023 3:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic view update using ViewMDXSet in PAW
- Replies: 4
- Views: 648
Re: Dynamic view update using ViewMDXSet in PAW
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...
- Thu Mar 02, 2023 3:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic view update using ViewMDXSet in PAW
- Replies: 4
- Views: 648
Re: Dynamic view update using ViewMDXSet in PAW
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...
- Wed Mar 01, 2023 8:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic view update using ViewMDXSet in PAW
- Replies: 4
- Views: 648
Dynamic view update using ViewMDXSet in PAW
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...
- Thu Feb 09, 2023 4:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1259
Re: Hierarchy security update require a call to SecurityRefresh Function
I tried the CellPutS but the trick didnt work.
- Thu Feb 09, 2023 3:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1259
Re: Hierarchy security update require a call to SecurityRefresh Function
I will give it a try and let you knowgtonkin 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);
- Thu Feb 09, 2023 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1259
- Thu Feb 09, 2023 10:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1259
Hierarchy security update require a call to SecurityRefresh Function
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 ...
- Tue Feb 07, 2023 1:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - How to identify empty subset through MDX
- Replies: 4
- Views: 953
Re: MDX - How to identify empty subset through MDX
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
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
- Mon Feb 06, 2023 6:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - How to identify empty subset through MDX
- Replies: 4
- Views: 953
MDX - How to identify empty subset through MDX
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...
- Mon Apr 11, 2022 3:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DIMIX check for element in a Hierarchy enabled dimension
- Replies: 4
- Views: 1481
Re: DIMIX check for element in a Hierarchy enabled dimension
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..
['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..