@declanr @gtonkin
Thanks for the solution. I really appreciate it.
After a little search I came across STRTOSET function and it worked like a charm.
Search found 19 matches
- Thu Jun 30, 2022 5:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IIF Mdx in IBM PAW not compiling
- Replies: 5
- Views: 1759
- Thu Jun 30, 2022 5:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IIF Mdx in IBM PAW not compiling
- Replies: 5
- Views: 1759
Re: IIF Mdx in IBM PAW not compiling
@devclanr @gtonkin Thanks for the quick reply. These solutions worked. Now in actual usecase, I need to return multiple measures. As you mentioned it cannot return members and sets, does it mean I have to write multiple StrToMember statements or is there a better way to do it. I have around 50 measu...
- Wed Jun 29, 2022 10:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IIF Mdx in IBM PAW not compiling
- Replies: 5
- Views: 1759
IIF Mdx in IBM PAW not compiling
Hello Everyone, I am writing an IIF statement in mdx but it is getting failed to compile. Scenario is based on the selection of version, different measure members should be shown. Currently tried mdxs 1. IIF( [Scenario].CurrentMember = "Elem1", [Dim_Measure].[MeasureA], [Dim_Measure].[Meas...
- Fri Apr 06, 2018 7:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cheking File Size
- Replies: 3
- Views: 2694
Cheking File Size
Dear All,
Is there any function in TI process to check the size of a file. I tried google and tm1 reference guide but couldn't find anything.
If not, is there a way to get the returnvalue from Executecommand().
Thanks.
Is there any function in TI process to check the size of a file. I tried google and tm1 reference guide but couldn't find anything.
If not, is there a way to get the returnvalue from Executecommand().
Thanks.
- Tue Mar 27, 2018 4:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting TM1 data in multiple sheet of workbook
- Replies: 2
- Views: 2396
Exporting TM1 data in multiple sheet of workbook
Dear All,
Can we export TM1 cube data to different sheets of same excel workbook?
Can we export TM1 cube data to different sheets of same excel workbook?
- Fri Dec 22, 2017 10:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Date Validation
- Replies: 1
- Views: 1934
Date Validation
I have an active form in which date is entered in yyyymmdd format.
I tried Custom validation but its not working.
How can I validate the data entered in the cell.
Thanks
I tried Custom validation but its not working.
How can I validate the data entered in the cell.
Thanks
- Fri Nov 03, 2017 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
Re: Child Elements are not visible under consolidations
As per my organization's restriction I am not allowed to post any files or screenshots.Wim Gielis wrote: ↑Tue Oct 31, 2017 7:46 am Can you supply screenshots please ?
Also, the .dim file for the relevant dimension.
- Tue Oct 31, 2017 6:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
Re: Child Elements are not visible under consolidations
What exactly are you expecting to see when you open the dimension? Are you expecting to see last 5 week, last 10 week and last 13 week, in order, all drilled down to their lowest level? If it is then just use this MDX in a subset: {TM1DRILLDOWNMEMBER( {[YourDimName].[last 5 week]}, ALL, RECURSIVE )...
- Mon Oct 30, 2017 5:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
- Mon Oct 30, 2017 4:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
Re: Child Elements are not visible under consolidations
Then how to show all elements. I want to automate it. I have created a dyanamic subset using mdx expression but still getting same results.
- Mon Oct 30, 2017 2:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
- Mon Oct 30, 2017 2:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
Re: Child Elements are not visible under consolidations
Hi this is not an issue but expected behaviour. The no-named subset view of a dimension you get when you open the subset editor is the natural underlying order of the dimension, which by default is I think the order in which the elements were added. You can fix the natural order of the dimension in...
- Mon Oct 30, 2017 1:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Child Elements are not visible under consolidations
- Replies: 14
- Views: 8106
Child Elements are not visible under consolidations
Dear All, I am creating a dimension with C level elements as last 5 week, last 10 week and last 13 week through TI. Now when I open the Dimension I am not getting all the elements under consolidations. but as soon as i click collapse and reexpand the same consolidated element then I get all the elem...
- Thu Oct 26, 2017 9:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic updation of child elements in Dimnsion
- Replies: 4
- Views: 2897
Re: Dynamic updation of child elements in Dimnsion
Thanks a lot Wim. Your article helped me a lot.Wim Gielis wrote: ↑Thu Oct 26, 2017 6:46 am See here for very similar time dimension manipulations:
http://www.wimgielis.com/tm1_relativeti ... ons_EN.htm
Appreciate your prompt reply.
- Thu Oct 26, 2017 6:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic updation of child elements in Dimnsion
- Replies: 4
- Views: 2897
Dynamic updation of child elements in Dimnsion
Hi all, I have a situation here. I have a dimension as "week". In this elements are stored as year and week no. For e.g 201740, 201741, 201742, and so on. My C level elements are last week, last4weeks, last8weeks. Every week I want last week element for e.g. 201742 as a child of last week,...
- Wed Aug 23, 2017 9:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
- Replies: 6
- Views: 4386
Re: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
Hi,
I am trying to parse the structure but i m not getting any suitable string function for this purpose. As far as i know SUBST() function requires a starting position which is not known in my case.
Please help me to parse the structure.
I am trying to parse the structure but i m not getting any suitable string function for this purpose. As far as i know SUBST() function requires a starting position which is not known in my case.
Please help me to parse the structure.
- Mon Aug 07, 2017 12:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
- Replies: 6
- Views: 4386
Re: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
The first thing is to parse the structure of the form stored in the cube} ElementAnnotations_DimensionName cube to get a list of files (in the OS) and their names (the names that are needed to display to users) After this, two operations must be performed 1) replace the names in the folder} app 2) ...
- Fri Aug 04, 2017 5:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
- Replies: 6
- Views: 4386
Re: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
Do you really think this is normal? :shock: :shock: :shock: How then should the system behave if your colleague append a file with the same name? In either case, you can serialize the form in the annotation cube and find the file name there Then you have two ways: Use changed name Change the name o...
- Fri Aug 04, 2017 7:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
- Replies: 6
- Views: 4386
Need help in attaching files in commentary without changing File Name - TM1 10.2.2
Dear All, I am attaching few files at node level. It is being stored in }attachments folder withing Data directory. I can open the files in their respective editors. But the problem now is the file names are getting changed. Some random string of of characters are coming in file name. For e.g i have...