Search found 1921 matches

by Wim Gielis
Thu Feb 21, 2019 12:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Input ON dbrw formula
Replies: 1
Views: 86

Re: Data Input ON dbrw formula

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 ?
by Wim Gielis
Thu Feb 21, 2019 12:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 7
Views: 121

Re: Temp View difference to Perm Views

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.
by Wim Gielis
Thu Feb 21, 2019 12:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget planning model with dynamically shifting costs
Replies: 6
Views: 106

Re: Budget planning model with dynamically shifting costs

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.
by Wim Gielis
Wed Feb 20, 2019 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA TM1 Web difference on Scale Divisor
Replies: 2
Views: 56

Re: PA TM1 Web difference on Scale Divisor

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...
by Wim Gielis
Tue Feb 12, 2019 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 security to users for specific elements in dimensions
Replies: 1
Views: 169

Re: TM1 security to users for specific elements in dimensions

Hello

Then you need to set up element security for the respective dimension.
by Wim Gielis
Sat Feb 09, 2019 1:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 398

Re: MDX StrToMember Error

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...
by Wim Gielis
Fri Feb 08, 2019 12:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 10
Views: 184

Re: TM1 Server crash on saving dimension (status Suspended)

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 ?
by Wim Gielis
Thu Feb 07, 2019 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives interacts with other VBA code in Personal.xlsb
Replies: 16
Views: 717

Re: TM1 Perspectives interacts with other VBA code in Personal.xlsb

Status: this case is now forwarded as a defect to development:
"PH08270 TM1 tab in Excel can not selected with Keyboard shortcuts"
by Wim Gielis
Thu Feb 07, 2019 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression for NextMember in case of variable source member
Replies: 4
Views: 116

Re: MDX expression for NextMember in case of variable source member

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 ...
by Wim Gielis
Thu Feb 07, 2019 2:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression for NextMember in case of variable source member
Replies: 4
Views: 116

Re: MDX expression for NextMember in case of variable source member

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 ...
by Wim Gielis
Thu Feb 07, 2019 12:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression for NextMember in case of variable source member
Replies: 4
Views: 116

Re: MDX expression for NextMember in case of variable source member

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...
by Wim Gielis
Thu Feb 07, 2019 12:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX expression for NextMember in case of variable source member
Replies: 4
Views: 116

MDX expression for NextMember in case of variable source member

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...
by Wim Gielis
Tue Feb 05, 2019 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for getting Parent and Children
Replies: 17
Views: 222

Re: MDX for getting Parent and Children

Or, shorter:

Code: Select all

DrilldownLevel( {[test2].[c]} )
by Wim Gielis
Tue Feb 05, 2019 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 202

Re: Ascii Quote Fun and Games

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.
by Wim Gielis
Tue Feb 05, 2019 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: can anyone suggest approach to write TI/ Rule for implementing interpolation in TM1
Replies: 8
Views: 354

Re: can anyone suggest approch to write TI/ Rule for implementing interpolation in TM1

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 ;-)
by Wim Gielis
Tue Feb 05, 2019 11:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Auto Recalculate for Cube Viewer
Replies: 2
Views: 90

Re: Auto Recalculate for Cube Viewer

Hello,

I haven't found it and I would be happy to use it !
by Wim Gielis
Tue Feb 05, 2019 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking for Underfed cells
Replies: 10
Views: 678

Re: Checking for Underfed cells

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...
by Wim Gielis
Mon Feb 04, 2019 9:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii output ,blank row at end
Replies: 3
Views: 78

Re: Ascii output ,blank row at end

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).
by Wim Gielis
Mon Feb 04, 2019 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to calculate AvergaeFYTD Rate
Replies: 2
Views: 78

Re: Rule to calculate AvergaeFYTD Rate

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...
by Wim Gielis
Mon Feb 04, 2019 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii output ,blank row at end
Replies: 3
Views: 78

Re: Ascii output ,blank row at end

Hello,

You cannot avoid it. It's caused by a carriage return character after outputting the last-but-one line in the text file.
Why would it bother you ? Does a different system need to have the file without the last empty line ?