TM1 Forum

hI,

I think this is what you need: viewtopic.php?f=3&t=15300&p=76080#p76080

You do not need "WRITE", "READ" is enough

Try to check whether your user can access to this slice in tm1web/architect: "[Security Type](user, [Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]"

Also check if the user has access to }Clients dimension and it's elements

Hi,
First of all, please clarify your version. The "Contributor" security settings are very different in different versions (starting with "}tp_owners", ending with date reservations)

Your profile says it's TM1 9.5. Is it right?

Hi,

I assume your user does not have have access to the "Security Type" cube or to dimensions' elements. Try to open this "[Security Type](user, [Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]" in Architect

Something I've waited for too long... Finally, I've got around to create an RFE:
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-517

There is a workaround, using a websheet. I've described it here: viewtopic.php?f=3&t=15793

The best I could implement for now, is using the Excel checkboxes: Assume we have a 2-dim cube. We need to replace the numeric values of a flag measure with a checkbox. First we need to enable Developer ribbon (right-click on ribbon, "customise the ribbon", enable "developer" ribbon) On the "Develop...

Hi,
Very useful indeed! That's because the views in PAW are MDX-based, and every dimension, which is not listed in "on 0", "on 1" and "where" clauses, goes to hidden "default" dimensions. And it works fine

Emixam wrote: ↑

Thu Feb 25, 2021 8:53 pm

I guess that's how TM1 works !

Yes, exactly:

1. Calculate consolidations
2. Suppress zeroes
3. Override consolidation value with C: formula

If you have at least one fed/input cell in consolidation's children, it will not be suppressed with zero suppression.

Everybody, This task with "Find all the ways to copy data from 2dim cube to 3dim cube" has really interested me I can come up with 4 another ways to do ths: Using tm1py Using pure REST API (for the most persistent) Using "relative proportional spread" Just_copy_and_paste =) Any other ideas?

This starts to remind me a " 1000 answers to "Measure tower height using barometer" question " meme =) Using a rule here will be much simpler than using a TI process: Target cube: SKIPCHECK; [] = N: DB('Source Cube', !Product, ATTRS(some mapping with source cube measures)); Source cube: SKIPCHECK; F...

subprocess with CellGetN using the Source Cube as Source to get the Amount - no, the subprocess uses the Source cube as a datasource. And does CellPutN to the target cube to one month (The Month should be specified in parameter "pMonth") What exactly besides running the Subprocess in the metadata -...

You are stubborn! =) Only one way comes to mind: Subprocess - copies one month Process - has "Month" dimension as a datasource, and "RunProcess" Subproecss in Metadata tab Compared to all examples described in previous topic: If you have large data volumes, you can parallel this. But ensure that you...

Hi Wim, If you are about the whole idea, the problem is to select aliases and store the codes, not aliases; so that when the alias changes, the rule using this codes will still work correctly. This is described by Paul Simon in detail in this topic If you are about calculation of "Code calc" column:...

Described another way to do this here

There is a great but undocumented solution In this topic, which did not suit one of my customers: they do not want to see huge GUID-like codes in their interface, even with the rule-based "name" measure near them. So I found another way to do this: Assume we have: Cube "test picklist" with 2 dimensi...

This! Really! Works! Thank you! How did you know about it?

This should me copied to useful code, tips & tricks forum

You need to reset the counter (LoopCounter = 1) before "While" in Data tab.

There are 2 ways: Create a subset in Month dimension with desired months and loop through it (using While, SubsetGetSize and SubsetGetElementName) in Data tab (easier) You can just write 12 CellPutNs in the Data tab like this: nNumber = nValue/12 CellPutN(nNumber, 'Target', vProduct, 'Jan'); CellPut...

If you cannot stop server, it's 100% not on client side, so Tm1p.ini configuration will not help.
Try to login and see what's happening in TM1top

What authentication mode do you use?

Hi

If I understand you right, you need to transfer data to the cube with More dimensions? Amount_All cube (2 dims) -> Target cube (3 dims).
If so, how will you split data between months? Equally split it, or repeat in each month?