TM1 Forum

Did you read the earlier replies ?

Well, BCave, that's not helping the OP for now, but hopefully someone stumbles on this after a Google search

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...

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...

Can you rebuild what is shown in the video ?

Pardon me, but what is BCI ?

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 ...

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...

As asked before, do you need 1 YTD (for today or yesterday for example), or each day's YTD ?

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...

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.

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.

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.

Indeed. A good number of really ugly and longwinded array formulas (confirmed with Ctrl-Shift-Enter) are hopefully gone now.

Did you right-click the process and set the relevant checkbox for security access ?

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...

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....

Apologies. I must have mixed up the concepts CurrentMember and TM1SubsetBasis. Please disregard my post.

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.

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.