TM1 Forum

@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.

@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...

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...

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.

Dear All,

Can we export TM1 cube data to different sheets of same excel workbook?

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

Wim Gielis wrote: ↑Tue Oct 31, 2017 7:46 am Can you supply screenshots please ?
Also, the .dim file for the relevant dimension.

As per my organization's restriction I am not allowed to post any files or screenshots.

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 )...

tm123 wrote: ↑Mon Oct 30, 2017 4:30 pm did you try to use { HIERARCHIZE( YourMDX ) } ?

Yes, i tried that also bt still no success.

tm123 wrote: ↑Mon Oct 30, 2017 2:34 pm Subset editor shows elements only once, so if you have multiple hierarchies in the dimension, it will not expand them all.

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.

declanr wrote: ↑Mon Oct 30, 2017 2:02 pm What tab did you run the dimensionsortorder on?

I have tried with Prolog, metadata and epilog. Same result with all three tabs.

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...

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...

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

Thanks a lot Wim. Your article helped me a lot.
Appreciate your prompt reply.

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,...

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.

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) ...

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...

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...