Search found 2280 matches

by Wim Gielis
Thu Jan 23, 2020 9:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 10
Views: 117

Re: TI MDX query of 2 different cubes

Did you read the earlier replies ?
by Wim Gielis
Thu Jan 23, 2020 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 10
Views: 117

Re: TI MDX query of 2 different cubes

Well, BCave, that's not helping the OP for now, but hopefully someone stumbles on this after a Google search :D
by Wim Gielis
Thu Jan 23, 2020 8:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 10
Views: 117

Re: TI MDX query of 2 different cubes

A TI process can only have one cube as a data source so the standard way of handling this is to have one cube as the data source (the one with the main intersection of cells you are trying to process) then in the Data tab of that process you issue a CELLGETN against the secondary cube to get it's v...
by Wim Gielis
Thu Jan 23, 2020 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 10
Views: 117

Re: TI MDX query of 2 different cubes

That's correct. There are other tools, like Jedox, that can do a kind of "join" on cube slices, or joining a cube slice and an Excel file, ... (something to dream about in TM1). Having said this, your best bet is indeed processing 1 set of cube data and exposing it to the data in the other cube slic...
by Wim Gielis
Wed Jan 22, 2020 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: dynamic shape
Replies: 5
Views: 339

Re: dynamic shape

Can you rebuild what is shown in the video ?
by Wim Gielis
Wed Jan 22, 2020 1:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 154

Re: Dynamic YTD Calculation on a Continuous Time Dimension

That's an option too. You can store the values against the measure and both daily value and YTD value are visible. Added benefit: you can see the YTD values of past days too. One point of concern might be, changing values for the past in retrospect. Then consolidations do not need to be reprocessed ...
by Wim Gielis
Wed Jan 22, 2020 1:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 154

Re: Dynamic YTD Calculation on a Continuous Time Dimension

Then create a TI process that creates the YTD. You can do so by looping over dates. You can 'unwind' that YTD total entirely (taking away all children), and add them again 1 after the other in your loop. Or, if it's just adding 1 day at a time, you can do the DimensionElementComponentAdd of just tha...
by Wim Gielis
Wed Jan 22, 2020 12:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 154

Re: Dynamic YTD Calculation on a Continuous Time Dimension

As asked before, do you need 1 YTD (for today or yesterday for example), or each day's YTD ?
by Wim Gielis
Tue Jan 21, 2020 10:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 154

Re: Dynamic YTD Calculation on a Continuous Time Dimension

The question is whether you need at any point in time just 1 cumulative total (for example today YTD) or whether you would need all daily YTD values for 1 year for instance. In the former case, just use a TI to break the dimension structures and rebuild. You could use other dimension totals for mont...
by Wim Gielis
Tue Jan 21, 2020 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Value is not computing after adding existing element to a dimension?
Replies: 4
Views: 178

Re: Value is not computing after adding existing element to a dimension?

What is the exact structure of the dimension ?
Does level 2 edited have children ?
Does it have a rule ?
What about dimension weights : all 1 ?
Please spend time to lay out the question in a proper way. If not you are losing your and our time.
by Wim Gielis
Mon Jan 20, 2020 11:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 208

Re: Unable to destroy Cell Security cube

You haven't followed the documentation by IBM:

https://www.ibm.com/support/knowledgece ... stroy.html

They have an example:
CellSecurityCubeDestroy('DataCube');

Leave out the first part of the name.
by Wim Gielis
Mon Jan 20, 2020 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 208

Re: Unable to destroy Cell Security cube

jamesbennett wrote:
Mon Jan 20, 2020 11:20 am
I hadn't - I wasn't aware of such an option - however having just ticked that I've rerun the process and get the same issue, 'Process Completed Successfully' but no impact on the cube.
Show us the code please.
by Wim Gielis
Mon Jan 20, 2020 11:14 am
Forum: Useful code, tips and tricks
Topic: Cryptic TM1 Messages Decoded
Replies: 70
Views: 45597

Re: Cryptic TM1 Messages Decoded

Indeed. A good number of really ugly and longwinded array formulas (confirmed with Ctrl-Shift-Enter) are hopefully gone now.
by Wim Gielis
Mon Jan 20, 2020 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 208

Re: Unable to destroy Cell Security cube

Did you right-click the process and set the relevant checkbox for security access ?
by Wim Gielis
Sun Jan 19, 2020 6:39 pm
Forum: Useful code, tips and tricks
Topic: Cryptic TM1 Messages Decoded
Replies: 70
Views: 45597

Re: Cryptic TM1 Messages Decoded

A new one to me. Using TM1ELLIST in Planning Analytics for Excel to show Members in a dimension. When I refreshed the sheet I got the #SPILL! message as the element list would have over-written values further down in the column i.e. spilled over I guess. This is an Excel error, not TM1/Planning Ana...
by Wim Gielis
Tue Jan 14, 2020 9:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: most stable version for PA upgrade
Replies: 3
Views: 243

Re: most stable version for PA upgrade

I would go for 2.0.8 unless you would want to use the feature: Use the ViewZeroOut TurboIntegrator function on MDX views (https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.2.0.0.doc/pa_nf_viewzeroout_support.html) or other features that were added in 2.0....
by Wim Gielis
Wed Jan 08, 2020 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 521

Re: TM1 MDX in TI Process

Apologies. I must have mixed up the concepts CurrentMember and TM1SubsetBasis. Please disregard my post.
by Wim Gielis
Tue Jan 07, 2020 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 521

Re: TM1 MDX in TI Process

Do not use CurrentMember. Make your expressions 'absolute' by specifying real element names and/or attributes and/or cube intersections, and so on. There is no CurrentMember inside a TI process.
by Wim Gielis
Tue Jan 07, 2020 8:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 3
Views: 566

Re: @= in active sheet formula

Thank you, that's useful knowledge.
I wonder when Microsoft is going to roll out those new functions to those who are not part of the Insiders program. Like 99% of the Office 365 population probably.