Search found 239 matches

by Elessar
Fri Apr 09, 2021 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Error: Get cell value: Cannot get cube cell value
Replies: 3
Views: 85

Re: MDX Error: Get cell value: Cannot get cube cell value

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
by Elessar
Fri Apr 09, 2021 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Contributor vs TM1web & Perspectives - Non-contributor users are not able to enter data in the cube
Replies: 2
Views: 77

Re: Contributor vs TM1web & Perspectives - Non-contributor users are not able to enter data in the cube

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?
by Elessar
Thu Apr 08, 2021 10:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Error: Get cell value: Cannot get cube cell value
Replies: 3
Views: 85

Re: MDX Error: Get cell value: Cannot get cube cell value

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
by Elessar
Tue Mar 16, 2021 6:48 pm
Forum: Enhancements
Topic: Checkbox data format
Replies: 0
Views: 567

Checkbox data format

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
by Elessar
Tue Mar 16, 2021 6:44 pm
Forum: Useful code, tips and tricks
Topic: Checkboxes for "flag" measures in TM1
Replies: 8
Views: 610

Checkboxes for "flag" measures in TM1

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...
by Elessar
Tue Mar 16, 2021 6:29 am
Forum: Useful code, tips and tricks
Topic: PAW Explorations after cube dimensionality changes
Replies: 3
Views: 377

Re: PAW Explorations after cube dimensionality changes

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
by Elessar
Fri Feb 26, 2021 6:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero Supression and C-level Rule 0 value
Replies: 6
Views: 347

Re: Zero Supression and C-level Rule 0 value

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.
by Elessar
Thu Feb 11, 2021 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfering data into Cube with less dimensions
Replies: 15
Views: 1172

Re: Transfering data into Cube with less dimensions

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?
by Elessar
Wed Feb 10, 2021 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Rules to transfer data into cube with less dimensions
Replies: 2
Views: 244

Re: Using Rules to transfer data into cube with less dimensions

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...
by Elessar
Tue Feb 09, 2021 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using subprocess to load data between cubes with different number of dimensions
Replies: 4
Views: 303

Re: Using subprocess to load data between cubes with different number of dimensions

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 -...
by Elessar
Tue Feb 09, 2021 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using subprocess to load data between cubes with different number of dimensions
Replies: 4
Views: 303

Re: Using subprocess to load data between cubes with different number of dimensions

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...
by Elessar
Mon Feb 08, 2021 4:48 pm
Forum: Useful code, tips and tricks
Topic: PickList to show Alias but store Element Name: Websheet approach
Replies: 2
Views: 565

Re: PickList to show Alias but store Element Name: Websheet approach

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:...
by Elessar
Mon Feb 08, 2021 4:11 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 15
Views: 17282

Re: PickList to show Alias but store Element Name

Described another way to do this here
by Elessar
Mon Feb 08, 2021 4:10 pm
Forum: Useful code, tips and tricks
Topic: PickList to show Alias but store Element Name: Websheet approach
Replies: 2
Views: 565

PickList to show Alias but store Element Name: Websheet approach

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...
by Elessar
Sat Feb 06, 2021 7:59 am
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 15
Views: 17282

Re: PickList to show Alias but store Element Name

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

This should me copied to useful code, tips & tricks forum
by Elessar
Fri Feb 05, 2021 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfering data into Cube with less dimensions
Replies: 15
Views: 1172

Re: Transfering data into Cube with less dimensions

You need to reset the counter (LoopCounter = 1) before "While" in Data tab.
by Elessar
Tue Feb 02, 2021 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfering data into Cube with less dimensions
Replies: 15
Views: 1172

Re: Transfering data into Cube with less dimensions

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...
by Elessar
Tue Feb 02, 2021 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Architect & Web are not responding when trying to login
Replies: 9
Views: 821

Re: TM1 Architect & Web are not responding when trying to login

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?
by Elessar
Tue Feb 02, 2021 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfering data into Cube with less dimensions
Replies: 15
Views: 1172

Re: Transfering data into Cube with less dimensions

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?