Search found 3293 matches

by lotsaram
Fri Sep 25, 2020 7:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 4
Views: 129

Re: MDX views, where / how are they evaluated?

How many cells? What is the MaximumViewSize param set at?
In TI the data is read one cell at a time so there isn't any hit to render the whole data set in a grid. That could be it.
by lotsaram
Fri Sep 25, 2020 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets In Rules
Replies: 2
Views: 81

Re: Subsets In Rules

I'm really surprised that this works given IBM has implemented something completely different in PAW with MDX aggregates replacing subsets as the mechanism for user defined consolidations.

Might be worth a query to IBM whether this will stay as a feature or is accidental and might disapear.
by lotsaram
Thu Sep 10, 2020 9:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Free Excel-to-Text converter
Replies: 20
Views: 2243

Re: Free Excel-to-Text converter

Or just set the quote character to empty string.
by lotsaram
Wed Sep 09, 2020 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock And Github vs Other Options
Replies: 9
Views: 259

Bedrock And Github vs Other Options

I have mulled over whether to respond to this post. There's obviously some pros and cons to stirring any potential controvercy, but I think there's enough benefit to rebutting/debunking some of the points above that it should be done. Yes I guess I do have a vested interest as although I have actual...
by lotsaram
Fri Sep 04, 2020 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: create report filters that are cascading
Replies: 3
Views: 123

Re: create report filters that are cascading

I appreciate the response, I am pretty new to this so i apologize for the ignorance however, I did make progress with it and i think i was able to complete what i wanted You may be new to Planning Analytics and this forum but not spraying the same question on multiple threads is just basic netiquet...
by lotsaram
Fri Sep 04, 2020 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use FAP dimensions in other cubes?
Replies: 5
Views: 180

Re: Use FAP dimensions in other cubes?

You already answered the questions. So I think you already knew the answer! ;) I had an issue with publishing data from within Cognos Controller to the FAP. The issue is probably due to the fact that I use the FAP dimensions in a new reporting cube? Yes probably. Everytime FAP is published the FAP c...
by lotsaram
Tue Sep 01, 2020 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetCreatebyMDX Union 3 elements or more
Replies: 3
Views: 120

Re: SubsetCreatebyMDX Union 3 elements or more

Wonder if someone know how to union 3 elements (or more if needed) in given code? Works with two elements perfect. Does not work when added 3rd element. The Union function can only merge 2 sets. But MDX also supports a union operator "+" which you can use as shorthand instead of {Union()}. e.g. { {...
by lotsaram
Thu Aug 27, 2020 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How accelerate a speed of spread of data tm1
Replies: 3
Views: 177

Re: How accelerate a speed of spread of data tm1

Other than the speed of the CPU on the server running the TM1 instance the thing affecting the time to perform a data spread is the number of leaf cells which need to be updated. Although to do a proportional spread you may be keying a value over just one cell. If the elements at the coordinates of ...
by lotsaram
Mon Aug 17, 2020 7:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best practice for a "widget" dimension
Replies: 7
Views: 249

Re: Best practice for a "widget" dimension

If your requirement is that users do manual data input then there's a 3rd and better option. Store the properties as attributes on the product or SKU dimension and make the data entry cube flat with respect to all the extra attribute dimensionality. Even with rules to prohibit data entry against inv...
by lotsaram
Fri Aug 14, 2020 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Caret (^) in MDX
Replies: 3
Views: 231

Re: Caret (^) in MDX

Thanks for the reply. Looking at the dimension, the element is no longer a child of the parent. So the dimension hierarchy has changed but the PAW mdx doesn't reflect this. So when you say Unless the MUN is saved in the PAW definition As opposed to what? Or another way of putting it, how do you avo...
by lotsaram
Fri Aug 14, 2020 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Caret (^) in MDX
Replies: 3
Views: 231

Re: Caret (^) in MDX

This is for the member unique name (MUN) as there is a distinction in TM1 between elements and members. Any element which has multiple parents within a hierarchy will be represented by as many unique members as it has parents. What the carets represent is the path to the element by traversing the an...
by lotsaram
Mon Aug 10, 2020 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: High Availability PA server
Replies: 4
Views: 281

Re: High Availability PA server

Yes with Rest API delta queries it's possible. After you initialize a monitoring/mirroring service each subsequent query can just retrieve cells with changed values since the last delta request and push these to the hot synced instance. For some customers requiring high availability on failover we h...
by lotsaram
Wed Jul 29, 2020 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Separate measure dimension for each cube VS one singular measure dimension for all cubes
Replies: 7
Views: 394

Re: Separate measure dimension for each cube VS one singular measure dimension for all cubes

The drawback is that this dimension now has 100+ elements, for all kinds of special exceptions etc. Cleanup is especially hard (how do you figure out if one element is used in a cube somewhere in a big model?), maintenance is hard, visually it is not appealing at all. Really you don't need anything...
by lotsaram
Mon Jul 20, 2020 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders without Skipcheck
Replies: 7
Views: 4285

Re: Feeders without Skipcheck

Hi, sorry to raise a very old post from the dead but I have 2 questions: 1) Is it still the case that feeding to another cube without skipcheck will result in no feeding? 2) Is there any scenario where having skipcheck off but feeders on makes any sense? Maren I don't think that #1 has ever been th...
by lotsaram
Mon Jul 13, 2020 7:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RptFilter
Replies: 2
Views: 239

Re: TM1RptFilter

TM1RptFilter does the same as the filter function in the Perspectives/Architect cube viewer. It only works if the view has a single dimension on rows.

I don't think you can call it a bug. It's always been like this, even if it sucks.
by lotsaram
Sat Jul 11, 2020 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 13
Views: 1103

Re: Expand function with numbers

Could it be that Expand rounds numbers to 4 decimal places? ... and therefore your “day part” goes to zero?

You could get around this by multiplying by a factor of 10^6 and then dividing again.
by lotsaram
Thu Jul 09, 2020 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW information for PAX
Replies: 10
Views: 567

Re: PAW information for PAX

I would 3rd it :D

No reason tm1py can't have a module for PAW API
by lotsaram
Tue Jul 07, 2020 9:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get TM1 Web Application name using the GUID
Replies: 2
Views: 258

Re: Get TM1 Web Application name using the GUID

I believe if cube cell comments are entered from the TM1 Application Web application then the GUID of the particular application shows up as an element in the }Annotation_ApplicationID control dimension which is used in the }CellAnnotations cubes. I don't ever use Application Web so in this dimensio...
by lotsaram
Mon Jul 06, 2020 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 1011

Re: STR(Num, len, dec) with only one argument

It should be simple to implement as well, just right click on the Function dimension and create the alias. If only we had access to the objects the next level down in the database. :lol: FWIW you can use CellGetS and CellGetN in place of DB in rules ... lol! I have always wanted some function alias...