TM1 Forum

Hi, You have 2 distinct values. Change one value into 'TEST' or so. Then, change the other value to what you had previously before the TEST. Then overwrite TEST with what you have previously on the second element. You can't have the same alias on different elements at the same time. So use a 3rd hel...

dharav9 wrote: ↑

Wed Feb 20, 2019 3:44 pm

Basically, it contains the DBRW formula. When user tries to pass the value on it then DBRW formula overwrites the formula.

I don’t follow you I’m afraid. So a DBRW formula overwrites another DBRW formula ?

paulsimon wrote: ↑

Wed Feb 20, 2019 11:02 pm

However, it is a problem with Temp Views.

Indeed. IBM should look into that because to me the temporary objects relate to the called process. Even if I call it 1,000 times, I don’t need/want to explicitly delete views and subsets - they’re temporary for a reason.

For me, definitely a TI approach.

Also, include a visual check whether both cubes match for the given project. If not it would (probably) mean that the transfer process did not run.

You could also include the transfer process in a chore.m and run it say every couple of hours.

The work around and arguably the better approach is to create consolidation measures above the unit level measure and use weights to divide by 1000 eg Then the lookup from Units, Thousands, Millions, just needs to select the appropriate measure which is then referenced in the Active Form DBRWs. Tru...

Hello

Then you need to set up element security for the respective dimension.

In the first code, StrToMember requires double quotes, not single quotes. Did you check out this very recent topic ? https://www.tm1forum.com/viewtopic.php?f=3&t=14492 In the second code, what is UserID ? Is it the fixed string 'UserID' and not dependent on the logged in user ? For reference, this w...

Ken Vuong wrote: ↑

Fri Feb 08, 2019 9:30 am

Thanks Steve.

I will upgrade to 206.
Cheers,

Ken

Anyone has an idea when 2.0.7 will be out ?

Status: this case is now forwarded as a defect to development:
"PH08270 TM1 tab in Excel can not selected with Keyboard shortcuts"

Agreed Steve. Your comments are valuable no matter how uses these functions. I think that it was more a challenge on how to use certain functions based on dynamic inputs (element in another subset). Until now I couldn't do a number of things when the 'input' is like this. With TI it would have been ...

Got it ! I'm answering my own question ;-) but I learned new stuff today, and the 2 previous posts are interesting too. I am now using the MDX function ParallelPeriod (which is supported). { ParallelPeriod( [Week].[level002], -1, TM1Member( [Week].[Current week].Item(0), 0) )} 08.png The amibiguous ...

Now, I have been banging my head against the wall on this one and I seem to have a solution: {StrToMember("[Week].[" + MemberToStr( TM1Member( [Week].[Current week].Item(0), [Week] )) + "]").NextMember} doesn't look that pretty though. Moreover, it fails if the element name exists in ANY other dimen...

Hi, [interesting topic, yet through own research and testing I answered my own questions. See last reply in this topic. Put differently, spoiler alert for the 3rd message in this thread :D ] Note that: This topic deals with the challenges in MDX of how to use certain functions based on dynamic input...

Or, shorter:

I have seen strange cases in the past with extended Ascii characters and try to stay away from there.
Which includes French accents like é, è, ê too. Not sure if this is still an issue nowadays, I am talking about some 5 years ago.

Bakkone wrote: ↑

Tue Feb 05, 2019 1:15 pm

Can I send an invoice?

Sure you can.
Not so sure if it will be paid, though.

Yesterday I received an email for my services. Pretty hopeless in my opinion

Hello,

I haven't found it and I would be happy to use it !

Hello, I would like to refrain from doing that, since it's all trial and error and guessing from my part. The chances of being wrong are rather high. Let's wait for IBM to come up with a list, instead of this speculation. Certainly when I noticed that there are commands that DELETE cubes and dimensi...

Maybe a batch file that removes the last character of the file ?
Or, if possible, instruct the other program to skip empty lines (which Turbo Integrator does by default -
empty lines do not give rise to Metadata and Data tab code execution).

If it works, it works... But I would tend to be in favour of custom rollups in the last dimension of the Exchange Rates cube. If needed, use Turbo Integrator to change (once a month) the components of the rollup and if it will greatly simplify the rule (at the expense of a TI process that you have t...