Search found 355 matches

by MarenC
Fri May 03, 2024 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Hi,

The feeder would be:

Code: Select all

[‘Volume’] => [‘Sales’];
How did ascheevel overtake Admin in the lead, given he was in the lead the previous week? :?

Maren
by MarenC
Thu May 02, 2024 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workflows - Getting started
Replies: 1
Views: 127

Re: Workflows - Getting started

Hi, PAW has the concept of Plans, and I believe Plans are IBM's idea of Workflow. As you say new features in PAW are released regularly and Plans isa fairly new thing, so probably quite a few new features are around Plans. I have seen it in use and it seems ok up to a point, but I would say that as ...
by MarenC
Tue Apr 30, 2024 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: using cellput to put the same value in 2 element values
Replies: 3
Views: 743

Re: using cellput to put the same value in 2 element values

Hi,

Why not have 2 cellputs within the

Code: Select all

IF (vSourceNum @= '1')
section;? One for Price Rate 1 and one for Price Rate 3?

Maren
by MarenC
Tue Apr 30, 2024 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Architect/Perspectives to be removed from PAoC
Replies: 3
Views: 386

Re: Architect/Perspectives to be removed from PAoC

And bear in mind that PAoC RDP and Arcitect/Perspectives are only available for Modlers not the general user population who have only ever had Workspace and PAfE So it makes no difference to the general users right? Doesn't change their experience at all. As for modellers and admins it takes someth...
by MarenC
Tue Apr 30, 2024 6:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Architect/Perspectives to be removed from PAoC
Replies: 3
Views: 386

Re: Architect/Perspectives to be removed from PAoC

To improve the user experience for our cloud clients
:evil:
by MarenC
Fri Apr 19, 2024 10:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Adam wrote: Sun Apr 14, 2024 12:45 pm Nothing. You have to hit enter first
Thats the cats job! :D
by MarenC
Thu Apr 11, 2024 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button in PAX with parameters
Replies: 1
Views: 629

Action Button in PAX with parameters

Hi, I suspect it has always been the case but I hadn't noticed before, but when you run a process from Excel (PAX or Perspectives) or from the websheet published in PAW/web, has it always been the case that when the user pressed the button and the process had parameters, the user would not be prompt...
by MarenC
Tue Apr 09, 2024 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Action Button Navigation
Replies: 1
Views: 209

Re: PAW Action Button Navigation

Hi,

Other than the browser back arrow I don't think so for PAW. Maybe one for the ideas portal.

Maren
by MarenC
Fri Apr 05, 2024 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

MDX can be used in: Dimension Subsets Cube Views in PAW, PAX In TI processes to create source views, build subsets. In PAX or Perspectives dynamic reports, and probably Universal reports but not got around to those yet. Just to be clear, re the last question, is that scenario theoretically possible ...
by MarenC
Wed Mar 27, 2024 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Assuming Consolidation TypeIn Spreading is not set to Deny then what ardi says (assuming the user wasn't an Admin)!
by MarenC
Tue Mar 26, 2024 5:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule to Propagate Values Between Dimensions
Replies: 7
Views: 2723

Re: TM1 Rule to Propagate Values Between Dimensions

Hi, I think we need more information, one bit of information that would be useful is what do you mean exactly by "But both this rule is not working."? Also, if you provide a single example of a product that isn't working, i.e. provide its 'at_CPG' attribute value and also the 'att_PPBU' at...
by MarenC
Tue Mar 26, 2024 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule to Propagate Values Between Dimensions
Replies: 7
Views: 2723

Re: TM1 Rule to Propagate Values Between Dimensions

Hi, On first reading this doesn't make sense to me, I think you say you want to update the product attributes based on the CPG attributes but you appear to be putting the rule in the CPG attribute cube, not the product attribute cube? I would have expected to see something like this: ['at_PBBU'] = S...
by MarenC
Mon Mar 25, 2024 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 8
Views: 2971

Re: Planning Analytics workspace is down

Hi Paxuser,

Thank you for taking the time to update this case.

Maren
by MarenC
Thu Mar 21, 2024 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing a lookup cube or Attribute in a TI Process
Replies: 6
Views: 2372

Re: Referencing a lookup cube or Attribute in a TI Process

Hi, vCCElements='!006 Main - Cost Centre'; What is this meant to be? Because when you use this: IF(ATTRS(vCC,vCCElements,vAttribute)@='Other'); You are asking is the attribute for an element called !006 Main - Cost Centre equal to other. I suspect you really want to ask what the attribute for the el...
by MarenC
Fri Mar 15, 2024 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Code: Select all

they may have set the ProportionSpreadToZeroCells cfg setting to False
Am I the only one who has made this the law!
by MarenC
Tue Mar 12, 2024 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 1152

Re: PAfE Issue on Win 11

Hi, Didn't the way PAX was installed completely change after PAW version 65, and don't IBM recommend that PAX should not be out of sync with PAW, something like within 3 versions? Doesn't explain the reason why it works on windows 10 I know but I would be interested to see what IBM respond with. Maren
by MarenC
Mon Mar 04, 2024 11:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Hi, Slice exports the data in the view to excel and allows for write back to the view/cube (via DBRW formulas). Note that the values will be the current values and not the values at the time of the slice. Snapshot exports the data in the view to excel as static values. Need excel for snapshots. Need...
by MarenC
Tue Feb 27, 2024 4:26 pm
Forum: Useful code, tips and tricks
Topic: An Introduction to MDX views
Replies: 2
Views: 2996

Re: An Introduction to MDX views

Hi George,

I don't know how much they pay you but it isn't enough! Great work.

Maren
by MarenC
Tue Feb 27, 2024 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Hi George,

I was definitely not aware of that feature, many thanks! You obviously keep your hear well to the ground to dig up all this stuff.

I doubt that is what the Quiz Master had in mind though as way of a solution...

Maren
by MarenC
Tue Feb 27, 2024 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 73
Views: 12127

Re: Ultimate Long TM1 quiz

Hi, Who said anything about poor admins wading through the data :D There are a few ways to automate using TI etc but I was thinking to myself that I would never rely on aliases if I were designing this and would have a code id, and then I noticed in your last screenshot that there is a code id of so...