Search found 512 matches

by PavoGa
Tue Jun 15, 2021 8:13 pm
Forum: General
Topic: Public Dataset suitable for TM1
Replies: 3
Views: 171

Re: Public Dataset suitable for TM1

CDC has a lot of downloadable datasets on health & death statistics.
by PavoGa
Fri Jun 11, 2021 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 1325

Re: Long time execution of TI after finished nested processes

Well, then here is a long shot: have you re-ordered the dimensions in the affected cubes? I have one cube that was taking an extraordinary amount of time to load and read with TI's and, like in this case, there was no indicator at all. Reordered the dimensions and processing time dropped dramaticall...
by PavoGa
Wed Jun 09, 2021 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 1325

Re: Long time execution of TI after finished nested processes

Is B_TECH_Flag_En_0 executed with TM1RunTI from }Drill_RunCalcEntity ? Have you turned on the logger for lock contention? What code is executing after the calls to B_TECH_Flag_En_0 ? It is hard to have any idea on this without know exactly what is occurring after those calls in the master process. I...
by PavoGa
Tue Jun 08, 2021 1:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 1325

Re: Long time execution of TI after finished nested processes

Here is a discussion about a process that seems to correlate with the problem you have described.

It may not have anything to do with it, but it was a process that suddenly went to taking way too long to complete and there were no log file entries providing a clue.
by PavoGa
Tue Jun 08, 2021 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 1231

Re: Rule set value to zero

Feeders are independent of the value (or non-value) stored in the cell. Regardless of whether the cell is blank or zero, if it is fed, TM1 has to deal with the overhead slowing performance of the consolidations. This is why feeder design is so important. There is nothing inherently wrong with storin...
by PavoGa
Fri Jun 04, 2021 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with CreateHierarchyByAttribute
Replies: 6
Views: 2616

Re: Problem with CreateHierarchyByAttribute

Unless I misread your question, the result you got is the one expected. If you have a look at the documentation for CreateHierarchyByAttribute , you'll see it's very limited in what it can do. It can create a 3-level hierarchy, with level 0 being your leaf elements, level 1 being the value of the a...
by PavoGa
Fri May 21, 2021 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with CreateHierarchyByAttribute
Replies: 6
Views: 2616

Re: Problem with CreateHierarchyByAttribute

Well, here is an update on this. As stated, there was a set of elements that were being ignored by the CreateHierarchyByAttribute function in a TI and through PAW, which I understand uses this function through the API. So, as it turned out we do have a single dimension for which we use this function...
by PavoGa
Wed May 19, 2021 10:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with CreateHierarchyByAttribute
Replies: 6
Views: 2616

Re: Problem with CreateHierarchyByAttribute

macsir wrote:
Wed May 19, 2021 8:41 pm
Just curious, what PAW and PAL version do you use?
PA: 2.0.9.1
PAW: 2.0.53
by PavoGa
Wed May 19, 2021 12:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with CreateHierarchyByAttribute
Replies: 6
Views: 2616

Problem with CreateHierarchyByAttribute

Having a problem with this function, as well as the manual method of creating an alternate hierarchy on an attribute through PAW. My time dimension has consolidations by year (2018, 2019, ..., 2023) with child periods of 201801...201812, 201901...201912, etc. Added an attribute called MonthName and ...
by PavoGa
Mon May 10, 2021 7:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Months and TimePeriod
Replies: 8
Views: 3524

Re: Months and TimePeriod

Your profile says you are on version 9.5? Is that true?
by PavoGa
Mon May 10, 2021 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Locking Actual Months in Forecast Scenario from User's Editing
Replies: 4
Views: 1544

Re: Locking Actual Months in Forecast Scenario from User's Editing

Have you looked at the TI CubeDataReservation functions? These will apply security to any slice of a cube and can be managed with TIs. I've tested them to see how they work, but have not actually used them in practice, so not familiar with their pros and cons. They did not seem overly difficult use.
by PavoGa
Tue May 04, 2021 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prior Year and Next Year in Rules: What is Faster?
Replies: 9
Views: 2396

Re: Prior Year and Next Year in Rules: What is Faster?

I think that advice is a little out of date and has been debunked via analysis now available with }StatsByRule. An attribute lookup is not faster than a string rule or numeric to string conversion. However, in terms of readibility and maintainability it woudl still normally be the recommended appro...
by PavoGa
Tue May 04, 2021 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Scan on an empty string
Replies: 2
Views: 1548

Re: Scan on an empty string

"Nothing from nothing leaves nothing"

-Billy Preston

Who knew Billy was a TM1 expert back in 1974. :lol:
by PavoGa
Mon May 03, 2021 1:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prior Year and Next Year in Rules: What is Faster?
Replies: 9
Views: 2396

Re: Prior Year and Next Year in Rules: What is Faster?

DB(), as in your example, is faster than ATTRS as well in every test I have ever performed.
by PavoGa
Mon Apr 26, 2021 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent Feeder query
Replies: 4
Views: 956

Re: Persistent Feeder query

Not that I am aware of but I will double check. Did you raise a defect? Or just turn Persistent Feeders off? Steve, sorry, I went back and reviewed my notes. I conflated an issue we had a couple of weeks ago which was a perfectly normal and expected feeder behavior vs. the problem with feeding to a...
by PavoGa
Mon Apr 26, 2021 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent Feeder query
Replies: 4
Views: 956

Re: Persistent Feeder query

Steve, I ran into the same problem about two weeks ago. We use persistent feeders as well. Observed and did the same things you did in resolving.

Question on your case: are any of the rules referencing alternate hierarchies?
by PavoGa
Thu Apr 22, 2021 11:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 14
Views: 2256

Re: Cube last data pull

Elessar wrote:
Thu Apr 22, 2021 1:22 pm
Hi,

You can use "load on Demand" parameter for this. Check it on every cube, and monitor the memory usage in }StatsByCube. The cubes which are not loaded - were not used.
Very cool idea.
by PavoGa
Wed Apr 21, 2021 6:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to for TI to write to multiple intersection in one line?
Replies: 8
Views: 1020

Re: Is there a way to for TI to write to multiple intersection in one line?

There is an outlier on this that can significantly impact performance writing to a cube as well and that is dimension order, although with what appears to be three dimensions in the cube, this may be an unlikely culprit. The first thing that needs to be corrected is the subset needs to be static as ...
by PavoGa
Mon Apr 19, 2021 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 1793

Re: Tm1s.cfg my own parameters

BTW, I don't like the idea of having prod and non-prod services sharing the same name. YMMV. My mileage varies greatly indeed. If I'm having users testing reports in a dev environment (especially complex reports which draw from multiple servers), websheets on TM1 web etc, etc, I want them using EXA...
by PavoGa
Fri Apr 16, 2021 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with Persistent Feeders. (PA Version 2.0.9.4)
Replies: 5
Views: 475

Re: Issue with Persistent Feeders. (PA Version 2.0.9.4)

I know you said the feeder is straightforward, but just to confirm, it does not have one of the elements using an attribute call to address a target cell does it? Second, if you process feeders on the input cube, nothing changes? A friend of mine had a problem with this yesterday with the difference...