Search found 367 matches

by PavoGa
Wed Oct 23, 2019 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with Parallel TI
Replies: 1
Views: 80

Re: Issue with Parallel TI

Are the threads going into a wait state while one finishes? If so, then probably a locking issue. A likely culprit is if this process is making any metadata changes.
by PavoGa
Wed Oct 23, 2019 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 5
Views: 211

Re: Best Practice : Migration into a production environment

This is pretty much exactly the use case that bedrock.hier.export.script was developed for. The process exports as TI code the script required to build dimensions (or hierarchies). There are options to filter on particular elements, attribute definitions, etc. It's a super easy way to generate this...
by PavoGa
Wed Oct 23, 2019 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 5
Views: 211

Re: Best Practice : Migration into a production environment

While you certainly can do it manually, it is error prone, and it doesn't catch things that are data and metadata related. Using Beyond Compare or WinMerge tools are great for processes and rules, but when it comes to comparing dimensions, or attribute data, or even cube data, that is where the man...
by PavoGa
Tue Oct 22, 2019 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 5
Views: 211

Re: Best Practice : Migration into a production environment

There are a number of different methods, many of which are elucidated on this forum. However, working two simple scenarios: 1) migrating everything from DEV to Prod Shutdown both servers (or run Save Data on DEV) and copy the DEV\data folder to PROD\data folder. Restart Prod instance. 2) migrating s...
by PavoGa
Tue Oct 22, 2019 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 14
Views: 1564

Re: Drill-through to a cube view

This has been awhile, but needed to update it (got a question on it today). If the subsets and the view exist and are updated, not created fresh, the drill through works fine with customized subset and view definitions. To avoid user conflicts, we added views on each cube and subsets on dimensions w...
by PavoGa
Mon Oct 21, 2019 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is used by whom? and for what purpose?
Replies: 2
Views: 293

Re: What is used by whom? and for what purpose?

@tomok

I think this one is for you. :D
by PavoGa
Fri Oct 18, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Compare Development and Production Server
Replies: 5
Views: 114

Re: Compare Development and Production Server

Beyond Compare (BC). I've used winmerge, but BC is better at matching up lines without false positives and tons of features. Use it for awhile and you'll throw rocks at winmerge. We have four environments (D, Q, S and P) that our code moves through and BC sessions are easy to setup to allow quick co...
by PavoGa
Fri Oct 18, 2019 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference between TI Text and Cube View
Replies: 8
Views: 187

Re: Difference between TI Text and Cube View

I do not know if this is what lotsaram was referring to, but an alternative is to use SLEEP(n) after the ExecuteCommand where n = milliseconds as another way of giving PS time to complete. With ExecuteCommand, if something goes wrong in the called script and it gets hung up, your TI will sit there p...
by PavoGa
Wed Sep 25, 2019 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Session Variables & RunProcess bug?
Replies: 0
Views: 383

Session Variables & RunProcess bug?

We have found that if the value of a session variable changes during a session, any processes executed through RunProcess will use the original session variable value setting . The value changes when the client logs out and back in. All processes executed directly as part of the user's current sessi...
by PavoGa
Sat Sep 14, 2019 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX statement when having two dimensions on the rows in Active form
Replies: 2
Views: 243

Re: MDX statement when having two dimensions on the rows in Active form

If an account has different spread methods depending on the BU, this cannot be done in a regular cube view with both dimensions on the rows. It can be done with the BU as a title dimension.

You might can in a websheet.
by PavoGa
Thu Aug 22, 2019 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do I increase my knowledge and basic concepts of tm1?
Replies: 8
Views: 3963

Re: How do I increase my knowledge and basic concepts of tm1?

Have not seen it mentioned, but the Bedrock White Papers are excellent resources as well.

Wim's MDX page is very good.
by PavoGa
Wed Aug 21, 2019 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How & why corrupted views of a cube is generated?
Replies: 8
Views: 3332

Re: How & why corrupted views of a cube is generated?

In my experience this happens when a view has been saved with static subsets or selected elements. Someone then deletes these elements effectively returning a null set and the view breaks. There are probably other reasons but the above is probably a frequent occurrence for newer users who do not us...
by PavoGa
Fri Aug 16, 2019 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 1744

Re: Rule or Process?

I may have missed it, but how are [daystaken] and [sales] loaded? From another cube via rules? Either way, seems obvious your measure should be sliced by the Banding. Adding individual measures to achieve this is really defeating the purpose and advantages of dimensional modeling and TM1. What happe...
by PavoGa
Fri Aug 16, 2019 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 1744

Re: Rule or Process?

Why not add another dimension for Bandings since that seems to be the way you want to be able to slice the data?
by PavoGa
Thu Aug 15, 2019 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 2994

Re: Lock Contention and RollBack

Did you try DIMIX( cDim |‘:‘| cHier, vEle) ? Do not know if this directed at my response, but I was not really clear. Where I'm using the temporary dimensions is when generating an email table of incorrect mappings/etc and, for instance the same account pops up 200 times. Only wanting one line for ...
by PavoGa
Thu Aug 15, 2019 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 2994

Re: Lock Contention and RollBack

I tested this and compared performances for DIMIX against SubsetElementGetIndex in a large dimenson (having more than 10k members). The result is DIMIX is 400 times faster than SubsetElementGetIndex. Hence, when I replaced DIMIX with SubsetElementGetIndex, my processes never finishes at all and kee...
by PavoGa
Thu Aug 08, 2019 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ATTRPUTS much slower on Planning Analytics vs 10.2.2
Replies: 6
Views: 961

Re: ATTRPUTS much slower on Planning Analytics vs 10.2.2

Okay, possible problem with the feeder. When the load was slow, did you test a subsequent update immediately after the first? If so, what were the results? When the process ran quickly after adding back the rules, was the cube unloaded prior to the run? Are you using persistent feeders? (if yes, may...
by PavoGa
Thu Aug 08, 2019 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ATTRPUTS much slower on Planning Analytics vs 10.2.2
Replies: 6
Views: 961

Re: ATTRPUTS much slower on Planning Analytics vs 10.2.2

I have not seen that type of performance difference in this type of update and have a dimension of over 475,000 elements updating four attributes. The TI is reading from an Oracle datasource and runs the update in approximately 90 seconds give or take. Do you have a rule file on the attributes cube ...
by PavoGa
Wed Aug 07, 2019 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 1503

Re: Feeder Issue Help Needed

It also appears you are doing a lot of addition in the rule. May consider breaking this gigantic rule into smaller ones by creating a consolidation that has components for each DB() call made. Native TM1 consolidations are much faster than rule-driven addition I believe you'll find.
by PavoGa
Wed Aug 07, 2019 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 10
Views: 1540

Re: Dimension Order in an MDX cube view as datasource

So the MDX Views are not the magic I was hoping for to force my TI process to loop through the source in a way I want it to then. Thanks for the clarification. That is an interesting conclusion drawn from lotsaram's post. Suspect that you are not fully understanding what we are saying. In a traditi...