Search found 3165 matches

by lotsaram
Mon Sep 16, 2019 5:57 am
Forum: Useful code, tips and tricks
Topic: Bedrock Issues
Replies: 13
Views: 6373

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: 3
Views: 155

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: 338

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: 425

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: 425

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: 1083

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: 248

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: 248

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: 1795

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: 1080

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: 874

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: 1168

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: 1619

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: 1281

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: 5608

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: 880

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: 5608

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 ...
by lotsaram
Sun Aug 18, 2019 6:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form with dynamic entry rows
Replies: 4
Views: 1235

Re: Active form with dynamic entry rows

You don’t need a helper measure and rules/feeding. You can do it with MDX which is better IMO. Both methods will require a refresh to get the extra row to appear. For MDX assuming you have a "data entry index" type dimension with placelolder measures named somethign like row1, row2, ...row99 then it...
by lotsaram
Fri Aug 16, 2019 6:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 1278

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 ...