Search found 890 matches

by gtonkin
Tue Nov 23, 2021 6:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Subsets Kill View Performance?
Replies: 4
Views: 721

Re: MDX Subsets Kill View Performance?

Are you deriving any string rules in your cube?
by gtonkin
Mon Nov 22, 2021 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1888

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

I am not exactly sure about what you mean In PAfE, go to your PAfE options then the top option IBM then scroll down in the window to Clear Cache. You may still need to make a change on the sheet to dirty it. Going back to Automatic calculation per Elessar's post may still be the correct way forward...
by gtonkin
Mon Nov 22, 2021 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1888

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

Try clear the cache and see if that helps - could be that PAfE is not seeing that the sheet is dirty again.
by gtonkin
Wed Nov 17, 2021 2:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 1888

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

What we found is that if you are Manual calculation, TM1ELLIST works the first time as you describe. Recalc does not do anything, unless you dirty the sheet i.e. tell PAfE that it needs to actually do a refresh. This also seemed to be the case with other formulas where PAfE is being efficient and on...
by gtonkin
Thu Nov 11, 2021 5:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert Existing Leaf Element into New or Existing Hierarchy
Replies: 6
Views: 2217

Re: Insert Existing Leaf Element into New or Existing Hierarchy

Still not following you on this. I created a new dimension called Widget, added members A, B, C I then added a new hierarchy called Alternate and created a rollup called Rollup. I copied A and pasted as a child to Rollup in Alternate - no issues. I right-clicked Rollup and added As Child B - no issu...
by gtonkin
Wed Nov 10, 2021 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert Existing Leaf Element into New or Existing Hierarchy
Replies: 6
Views: 2217

Re: Insert Existing Leaf Element into New or Existing Hierarchy

Try copy and paste (with Ctrl+V) it as child or into the new hierarchy. The add is only for new to the dimension, not new as in adding to a parent.
by gtonkin
Mon Nov 08, 2021 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI View Execution vs MDX View
Replies: 13
Views: 3757

Re: TI View Execution vs MDX View

TBH, not sure then - MDX looks reasonable - should be 2 columns and dim3-8 stacked on rows. As a stab in the dark, have you tried rationalising from Dim8 backwards by setting Dim8 to the Total member, then Dim7 etc to see if there is something happening between the quantum of members returned by the...
by gtonkin
Mon Nov 08, 2021 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX to update current week in a Cube View dynamicly
Replies: 10
Views: 3569

Re: TM1 MDX to update current week in a Cube View dynamicly

What is the structure of your control cube? You would need to specify the dimension/member combination for each dimension to read from the exact address in which your data is stored. If you leave out a dimension, it will not work as desired. Try get the first part working i.e. the StrToMember - don'...
by gtonkin
Sun Nov 07, 2021 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI View Execution vs MDX View
Replies: 13
Views: 3757

Re: TI View Execution vs MDX View

Can you share the code? Are you using Non Empty?
by gtonkin
Fri Nov 05, 2021 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX to update current week in a Cube View dynamicly
Replies: 10
Views: 3569

Re: TM1 MDX to update current week in a Cube View dynamicly

TM1SubsetToSet simply inserts the members of the referenced subset into the set you are building with your MDX. I often have a subset with last n Periods and add this with the current period - makes it easier, especially for users on web/mobile etc. where there is not set editor access and the dropd...
by gtonkin
Fri Nov 05, 2021 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX to update current week in a Cube View dynamicly
Replies: 10
Views: 3569

Re: TM1 MDX to update current week in a Cube View dynamicly

I am assuming you have the current week in a subset or control cube somewhere. If you have it in a subset, you could try the following: {TM1Member( [Period].[Period].[Current Month].Item(0),0 ), TM1SubsetToSet([Period].[Period],"All N")} That should give you the current week as the first element and...
by gtonkin
Thu Nov 04, 2021 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX RefreshAllData()
Replies: 7
Views: 3099

Re: PAX RefreshAllData()

Still fairly certain that you need to uninstall IBM framework for Office as you are running PAfE 2.0.68
by gtonkin
Wed Nov 03, 2021 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX RefreshAllData()
Replies: 7
Views: 3099

Re: PAX RefreshAllData()

Example 1 works in my books. I had an issue previously with the IBM Framework for Office clashing with something when I updated to PAW 2.0.65 What version are you on? Did you previously enable the IBM Framework for Office as a COM add-in as well? With PAfE 2.0.65 onwards, make sure that all PAfE and...
by gtonkin
Sat Oct 30, 2021 6:57 am
Forum: Useful code, tips and tricks
Topic: Troubleshooting integrated login issues with users originating from multiple domains
Replies: 0
Views: 4429

Troubleshooting integrated login issues with users originating from multiple domains

At some clients users connect from multiple domains. Typically all that is needed is an update on the UNIQUEID to have the relevant domain included there. Sometimes however some users cannot connect and you need to try trace which domain TM1 is actually seeing them originate from. Up until now this ...
by gtonkin
Fri Oct 29, 2021 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA on IBM cloud, and RDP sessions
Replies: 5
Views: 2573

Re: PA on IBM cloud, and RDP sessions

This article may help.
FYI my setup is 3 monitors and I had the RDP session on all three. Have not tried the other options to limit to 2 specific monitors etc.
by gtonkin
Fri Oct 29, 2021 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA on IBM cloud, and RDP sessions
Replies: 5
Views: 2573

Re: PA on IBM cloud, and RDP sessions

HI Tom,
I have my connections saved to .RDP files and use these to connect.
If I tick "use all my monitors for the remote session" on the display tab, it does indeed spread across my monitors.
HTH - and welcome to the forum!
by gtonkin
Thu Oct 28, 2021 7:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX did not work in TI
Replies: 6
Views: 2851

Re: TM1 MDX did not work in TI

Not seen this before but try replacing the , in the wildcard string with another * and see if there is perhaps something going wrong due to a comma in the string.
by gtonkin
Tue Oct 26, 2021 7:11 am
Forum: Useful code, tips and tricks
Topic: Undocumented Date Functions
Replies: 5
Views: 2604

Undocumented Date Functions

Found some useful functions after a bit of sleuthing: Sample TI process: sYear=YRS(TODAY); sMonth=MOS(TODAY); sDay=DYS(TODAY); asciioutput('debug.txt',sYear, sMonth, sDay); Gives you: "2021","OCT","26" The return of the 3 character month is the kicker for me! Works in TI and Rules. All three functio...
by gtonkin
Fri Oct 22, 2021 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Distinguish String elements in an MDX
Replies: 19
Views: 9512

Re: Distinguish String elements in an MDX

Mark RMBC wrote:
Fri Oct 22, 2021 8:27 am
Hi George,

The Member_Weight does work, how long has that been around?

I obviously need to pay more attention ;)

regards,

Mark
Probably since forever but undocumented like many other functions and properties unfortunately.
by gtonkin
Fri Oct 22, 2021 8:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Distinguish String elements in an MDX
Replies: 19
Views: 9512

Re: Distinguish String elements in an MDX

Try something like this Mark:

Code: Select all

FILTER(TM1SubsetAll([account1]),
[account1].currentmember.properties("MEMBER_WEIGHT")<>"1.000000")

or
FILTER(TM1DrillDownMember(TM1SubsetAll([test]),ALL,Recursive),
StrToValue([test].currentmember.properties("MEMBER_WEIGHT"))=-1)