Search found 3167 matches

by lotsaram
Sun Oct 06, 2019 3:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using TI to recreate a dimension changes not being picked up
Replies: 6
Views: 446

Re: Using TI to recreate a dimension changes not being picked up

What you’re saying really doesn’t make sense. Any piece of code will do exactly what it has been programmed to do. So either there’s a mistake in your code, or the file isn’t being updated when you think it is or like you think it should have been, or the process isn’t running when you think it is. ...
by lotsaram
Fri Oct 04, 2019 7:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple Cubes vs One Cube
Replies: 5
Views: 632

Re: Multiple Cubes vs One Cube

I also use this idea of the 'dummy element' too but we were discussing the other day about the idea of having this 'dummy element' alone in an alternative hierarchy, does anyone know if it'll be better for the performance of the model? How can we measure/see the impact of both approaches? It won't ...
by lotsaram
Mon Sep 16, 2019 5:57 am
Forum: Useful code, tips and tricks
Topic: Bedrock Issues
Replies: 14
Views: 8417

Re: Bedrock Issues

Bedrock v2 is at least 6 years old.
All I can say is that every effort was made to maintain backwards compatibility between v3 & v2.

Anyone still using v2 ... really shouldn't be.
by lotsaram
Mon Sep 16, 2019 5:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with dimension Leaves
Replies: 4
Views: 373

Re: Working with dimension Leaves

To delete a leaf element from all hierarchies you delete it from the Leaves hierarchy. e.g. HierarchyElementDelete( sDim, sHier, sEle ); Deletes the element from not only the Leaves hierarchy but also the same named hierarchy and any other hierarchies in which the element exists. This is because lea...
by lotsaram
Thu Sep 12, 2019 7:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about formatting rule calculated cells in TM1
Replies: 3
Views: 414

Re: Question about formatting rule calculated cells in TM1

The documentation explains it. To ensure that TM1 applies the format for the cube measures, position the dimension containing the measures as the bottommost column dimension. TM1 first checks the elements in the column dimension for display formats. If dimensions are stacked, TM1 checks from the bot...
by lotsaram
Mon Sep 09, 2019 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 937

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

The problem with having the hierarchy or ElementAttributes on columns is that you then have a variable number of columns coming in to the TI. I want to create something re-usuable so it can be used against any dimension hierarchy all of which can have different numbers of attributes. So I want to s...
by lotsaram
Mon Sep 09, 2019 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 937

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Sorry but I don't understand what isn't working with ViewCreateByMDX. Surely there you can put the hierarchy on rows or columns (whichever you like) and the attributes likewise. As long as you have a hierachy on axis 0 then the MDX is OK and there shouldn't be an issue?! Even if there is some issue ...
by lotsaram
Wed Sep 04, 2019 5:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 5056

Re: How to make system appear "offline" - TM1Web login unavailable

This sounds useful! But does unload work for }ClientProperties?
by lotsaram
Mon Sep 02, 2019 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Attrput and ElementAttributes Cube
Replies: 4
Views: 309

Re: Attrput and ElementAttributes Cube

This argument is undocumented (but widely known and used). It comes before the locale code.
by lotsaram
Mon Sep 02, 2019 1:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Attrput and ElementAttributes Cube
Replies: 4
Views: 309

Re: Attrput and ElementAttributes Cube

For sure sometimes the error message returns can be misleading. If using AttrPutS to an alias and the string is the same as the principal name then the value won't be stored, versus with CellPutS it will be. I guess this was benefoicial in the bad old 32 bit days where every byte of memory was preci...
by lotsaram
Thu Aug 29, 2019 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionAttrs
Replies: 15
Views: 5194

Re: DimensionAttrs

I think you misunderstand what DimensionAttrS is for. This is really for retrieving attributes of the dimension (typically only ever Caption). This is not for element attributes!
by lotsaram
Thu Aug 29, 2019 6:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Leading zeros in AsciiOutPut being dropped
Replies: 4
Views: 4381

Re: Leading zeros in AsciiOutPut being dropped

I'm pretty sure Wim is correct and this is just Excel trying to be "helpful" by converting anything that looks like a number into a number. This is decidedly unhelpful when dealing with date strings and account numbers. If you open in notepad you can verify pretty easily that the account numbers are...
by lotsaram
Wed Aug 28, 2019 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 4
Views: 3832

Re: RunProcess explanation

So would I put a number of RunProcess statements in one TI master process and just run the master process. So would they all run at the same time? For example on the prolog of the master process, RunProcess('ProcessA', 'Month',1) RunProcess('ProcessA', 'Month',2) RunProcess('ProcessA', 'Month',3) R...
by lotsaram
Mon Aug 26, 2019 9:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 4904

Re: What's coming up in the TM1 Server?

But I always tend to think about things like Canvas and all these other things beeing developed on top of the api. As much as I love it. I always wonder about customers using other frontends lowers the threshold to just move onto a different platform altogether. Im sure there are peoplpe at cubewis...
by lotsaram
Fri Aug 23, 2019 8:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export list of System Names
Replies: 4
Views: 4731

Re: Export list of System Names

You can get them from the }externals folder in your data directory. Or within the }Applications folder you open the .blob file corresponding to the application entry and open it with a text editor and the ENTRYREFERENCE property contains the hyperlink with the system name from }Externals. I think t...
by lotsaram
Thu Aug 22, 2019 1:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading fields from csv without knowing the type of value
Replies: 6
Views: 4284

Re: loading fields from csv without knowing the type of value

gtonkin wrote:
Thu Aug 22, 2019 10:07 am
Unfortunately there is no ISNUMBER function so you will need do your own tests.
No there isn't. But if you don't want to iterate the string character by character testing for a number or decimal then probably the closest you can get is
IF( sValue @= NumberToString( Numbr( sValue ) )
by lotsaram
Wed Aug 21, 2019 3:22 pm
Forum: Bugs
Topic: CellIncrementN and BatchUpdate Mode
Replies: 8
Views: 8077

Re: CellIncrementN and BatchUpdate Mode

Cube to cube processing operations are typically very fast (say >40K cells/second). Where it is slower than this the reasons are usually 1. dynamic subsets 2. where source & target are contained in the same cube slice 3. data input triggering heavy feeding Solve 1. by never using dynamic subsets in ...
by lotsaram
Wed Aug 21, 2019 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How & why corrupted views of a cube is generated?
Replies: 8
Views: 2654

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

habibullah.sayyed wrote:
Wed Aug 21, 2019 10:46 am
Hie everyone,
My query is about corrupted view of cube. Please explain it in as simple way as you can and in detail.
Thanking you in advance.
Define "corrupted".
by lotsaram
Wed Aug 21, 2019 12:41 pm
Forum: Bugs
Topic: CellIncrementN and BatchUpdate Mode
Replies: 8
Views: 8077

Re: CellIncrementN and BatchUpdate Mode

Sorry for performing necromancy.. Does anyone have update on this? Just encountered exactly the same issue as Paul on PA 2.0. BR, Simon Why are you using BatchUpdate? This is something I haven't used since ParallelInteraction was introduced. I really don't see a need for it in PA. If you think I'm ...