Search found 437 matches

by PavoGa
Thu Oct 15, 2020 8:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule for internal cell ref and alternate hierarchies
Replies: 0
Views: 545

Rule for internal cell ref and alternate hierarchies

So, I want to reference a cell within a cube located at the intersection of several alternate hierarchies. Do not want to use DB() to an external cube or on this internal reference because speed of [ element1, element2, ..., elementN ] is faster. However, the only thing that seems to work is DB(). H...
by PavoGa
Mon Oct 12, 2020 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut on MDX views
Replies: 2
Views: 416

Re: ViewZeroOut on MDX views

Has anyone used ViewZeroOut against a view created by MDX? It is failing and complaining that the element in the hierarchy it needs cannot be found. It is the hierarchy element, not the hierarchy it is complaining cannot be found, as I changed the element name to determine exactly what it was compla...
by PavoGa
Mon Oct 12, 2020 12:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OptimusPy - Ideal dimension order finder
Replies: 8
Views: 772

Re: OptimusPy - Ideal dimension order finder

Really neat utility. Getting better reductions in memory footprint vs. the built-in optimizer. Ran into some issues with query speed last week, but conducting some additional testing.
by PavoGa
Thu Oct 08, 2020 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut on MDX views
Replies: 2
Views: 416

Re: ViewZeroOut on MDX views

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 PavoGa
Thu Oct 08, 2020 12:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut on MDX views
Replies: 2
Views: 416

ViewZeroOut on MDX views

2.0.09 was supposed to allow the use of ViewZeroOut again MDX views. As mentioned in some other threads, ViewZeroOut was virtually useless if leaf elements existed in alternate hierarchies but not the base dimname:dimname. I was hoping for a resolution of this issue with ViewZeroOut against MDX subs...
by PavoGa
Thu Sep 24, 2020 7:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security on Alternate Hierarchy?
Replies: 2
Views: 315

Re: Security on Alternate Hierarchy?

A shot in the dark here, but have you tried applying security to the }Hierarchies_dimname dimension?
by PavoGa
Thu Sep 24, 2020 7:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Extract Cube data into csv file using TI process
Replies: 3
Views: 385

Re: How to Extract Cube data into csv file using TI process

I'm still new to TM1 and I need help to extract data from a cube and save it as csv using TI process. I would recommend investing in some training. I'm not having a go at you in saying that but this is TM1 101, so if you can't do this you're really going to struggle. There are a lot of consultants ...
by PavoGa
Thu Sep 24, 2020 7:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets In Rules
Replies: 2
Views: 186

Re: Subsets In Rules

And we have some more coming don't we? :D
by PavoGa
Sun Aug 30, 2020 2:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock And Github vs Other Options
Replies: 9
Views: 399

Bedrock And Github vs Other Options

Have been using my own as well for years.
by PavoGa
Fri Aug 21, 2020 5:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process with batch entry a value every second times
Replies: 2
Views: 414

Re: Process with batch entry a value every second times

I think what is happening here is the ViewZeroOut is contained within the transaction of the overall process; it does not commit until the process completes. So, the command line operates in a different thread and actually performs its work (and commits its changes) with the master process waiting u...
by PavoGa
Wed Jul 15, 2020 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ElementParent rule in Hierarchies
Replies: 5
Views: 644

Re: ElementParent rule in Hierarchies

I was reading that you don't need the dimension qualifier in a DB. I also read that you shouldn't use the pipe. 'By Bucket1': ElementParent('Products','By Bucket1',!Products,1) Is this incorrect? Maren I've not read that on the pipe, but we do use it without any problems. However, I am UP with not ...
by PavoGa
Tue Jul 14, 2020 12:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ElementParent rule in Hierarchies
Replies: 5
Views: 644

Re: ElementParent rule in Hierarchies

In the DB statement, the argument for the hierarchy element has to be fully qualified:

'dimname:By Bucket1:' | ElementParent('Products','By Bucket1',!Products,1)
by PavoGa
Tue Jun 23, 2020 12:43 pm
Forum: General
Topic: A little bit of help with world domination!!
Replies: 9
Views: 2562

Re: A little bit of help with world domination!!

Sorry Jim, I did not look at this until too late. Would have voted for you though!
by PavoGa
Mon Jun 08, 2020 7:45 pm
Forum: Useful code, tips and tricks
Topic: }Stats cubes tools
Replies: 4
Views: 1312

Re: }Stats cubes tools

:) Thanks!
by PavoGa
Mon Jun 08, 2020 3:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Self Triggering
Replies: 10
Views: 1086

Re: TM1 Process Self Triggering

Thanks ykud!! As you and declanr said, the reason for rollback is that one of the sub processes was having a cubesavedata over a particular cube . That was the reason for roll back , i removed it but facing another issue which was the reason for above lock you had mentioned I am having a sub proces...
by PavoGa
Wed Jun 03, 2020 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements without any data
Replies: 28
Views: 3576

Re: Deleting elements without any data

What wizardry is this? I never heard of this DimensionDeleteElements function! Anyone know since which version this one has been with us? October 2018, PA 2.0.6 https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/pa_nf_delete_leaf_elements_ti_process.htm...
by PavoGa
Tue Jun 02, 2020 12:26 pm
Forum: Enhancements
Topic: MDX Object type for picklists
Replies: 5
Views: 657

Re: MDX Object type for picklists

Voted.
by PavoGa
Mon Jun 01, 2020 7:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through custom views/subsets
Replies: 7
Views: 877

Re: Drill Through custom views/subsets

Can you be more specific about your issues Ty? We are using the same method that Paul indicated and not seeing any issues with functionality. (Yes of sure there are some issues that the object names displayed in the UI don't seem to be updated, but the more important thing is that it actually works...
by PavoGa
Mon May 11, 2020 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert a Subset into a Subset through TI
Replies: 4
Views: 578

Re: Insert a Subset into a Subset through TI

This can be done through the Architect Subset Editor. However, can it be done through a TI? No it can't. Paste via Perspectives/Architect is the only way to achieve this. (Unless you want to roll your own UI with the old C API). There is a difference between a subset file created through the UI and...