Search found 3515 matches

by lotsaram
Wed Feb 14, 2024 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Subset TI Data Source Alias
Replies: 4
Views: 829

Re: Dimension Subset TI Data Source Alias

Is it a limitation that aliases do not show when the data source is Dimension Subset? Not a limitation, a feature! ;) It doesn't matter what alias is assigned to subsets used in datasources (views and subsets). From a data source variable perspective TI will always read the principal name. As sugge...
by lotsaram
Tue Feb 06, 2024 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA on IBM Cloud - Uploading users
Replies: 4
Views: 1173

Re: PA on IBM Cloud - Uploading users

I'm not convinced that being able to create users but not have the user accounts be properly active and able to be used (that is log onto the system with the account) is a really useful feature.
by lotsaram
Fri Jan 05, 2024 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Dependency Query
Replies: 2
Views: 828

Re: Rule Dependency Query

If the rule sheet for both cubes reference the attributes of the same dimension via a lookup, something like a prior period lookup then does this create a dependency between my two cubes? No. in Cube A ['Measure'] = DB ('Cube A' , ......, DB('}ElementAttributes_Period' , !Period, 'Prior') ,....); i...
by lotsaram
Mon Dec 11, 2023 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16909

Re: ViewZeroOut doesn't work

EP_explorer wrote: Sat Dec 09, 2023 11:28 am
burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
Why are you using a 3 year old version?
by lotsaram
Mon Dec 04, 2023 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM usage exploding with CubeUnload and ViewConstruct
Replies: 5
Views: 11783

Re: RAM usage exploding with CubeUnload and ViewConstruct

Why don't you export data to CSV on production and load the CSV in Test/Dev? It seems to me that this would be a better solution. - more scope for automation since at the end of the export the process to load the file could be chained by tm1runti or rest call - presumably the whole history doesn't c...
by lotsaram
Wed Nov 15, 2023 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance drop between 2.0.9.1 and 2.0.9.15
Replies: 7
Views: 10093

Re: Performance drop between 2.0.9.1 and 2.0.9.15

I can only agree that there is absolutely no point in testing an upgrade to 2.0.9.15 as this is already a year old. Go with the latest release: 1. as you will get better support if needed from IBM or your BP rather than being helpfully asked to upgrade 2. if you are working for a organization with g...
by lotsaram
Wed Nov 15, 2023 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 18799

Re: REST API Dimension Clone

There's no single endpoint to duplicate a dimension. You can get the elements and structure, but you then need separate calls to create the attributes and then copy the data.
by lotsaram
Tue Nov 14, 2023 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to ViewZeroOut }bedrock.cube.view.create
Replies: 3
Views: 7561

Re: Unable to ViewZeroOut }bedrock.cube.view.create

Declan's answer is correct. You need to use ExecuteProcess not RunProcess. 1. So that all processes will be part of the same commit transaction, which makes temp objects accessible to other processes whihc are part of the same transaction. 2. So that the execution is serial and the calling process w...
by lotsaram
Tue Nov 14, 2023 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10364

Re: Tm1 Model - Limit Overall RAM Usage

Not being able to shutdown the instance would seem to be a fatal flaw in using this! What would happen to a long-running TI process that was processing rule calculated cells and consequently growing the calculation cache? If memory limit exceeded does the TI process just error? Or does it do somethi...
by lotsaram
Wed Nov 08, 2023 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10364

Re: Tm1 Model - Limit Overall RAM Usage

You can't.

TM1 will eat up all available memory until it runs out.

And then it is paging, hanging and crashing time.
by lotsaram
Thu Oct 12, 2023 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Dependency with DB Function - How Smart?
Replies: 3
Views: 6544

Re: Cube Dependency with DB Function - How Smart?

We have an issue at the moment when updating a meta-data cube that is relied on heavily throughout our larger data cubes that it seems to be causing a constant recalc everytime a view is pulled once it's updated. The odd thing is, the measure that is being updated I do not believe is in ANY rules. ...
by lotsaram
Wed Sep 20, 2023 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock delimiter
Replies: 5
Views: 3795

Re: Bedrock delimiter

I think if you just comment out lines 90-92 on the prolog then this should suffice. If( pThousandSeparator @= '' ); pThousandSeparator = ','; EndIf; You can raise a ER at https://github.com/cubewise-code/bedrock/issues The check for empty paramater and inserting a default makes sense. To achieve non...
by lotsaram
Mon Sep 18, 2023 7:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export }-Cubes with Bedrock
Replies: 3
Views: 2093

Re: Export }-Cubes with Bedrock

The process }bedrock.hier.export will include all attribute names and type in the header, before the body which contains the hierarchy structure and attribute values. So if you want the attribute values it will be in that file. If you aren't interested in the structure you could always just ignore a...
by lotsaram
Mon Sep 11, 2023 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on MDX
Replies: 4
Views: 776

Re: Need help on MDX

CURRENTMEMBER.PROPERTIES work fine but CURRENTMEMBER.PROPERTIES().PROPERTIES() doesn't work. And why on earth would you expect this to work? CurrentMember is obviously a member CurrentMember.Properties("propertyName") returns a string You cannot pass a string into an expression which requ...
by lotsaram
Fri Sep 08, 2023 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock And Github vs Other Options
Replies: 22
Views: 21434

Re: Bedrock And Github vs Other Options

The key point, THE. KEY. POINT. is that if Bedrock was still maintained entirely in house by Cubewise such that each release was an unvarying quantity that could be comprehensively tested, there would be a degree of certainty about the functionality for that version of it . As it was released into ...
by lotsaram
Wed Sep 06, 2023 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX which takes Value from Cube
Replies: 12
Views: 7454

Re: MDX which takes Value from Cube

Why would a new user with no post history necromance a thread from 6 years ago just to troll someone? Very weird stuff. Maybe it's a chatbot/trollbot?
by lotsaram
Wed Sep 06, 2023 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1148

Re: Any tm1web log setting to get user access websheet info

Niko wrote: Sat Sep 02, 2023 4:59 pm I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first.
If you are lucky enough to have Pulse, and it is properly configured then Pulse captures this information and it can be reported.
by lotsaram
Wed Aug 30, 2023 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirantis mandatory for PAW
Replies: 10
Views: 2019

Re: Mirantis mandatory for PAW

WilliamSmith wrote: Wed Aug 30, 2023 12:45 pm Are you saying the long term road map is to migrate PAW away from running on Windows server?
Long term roadmap? :lol:
by lotsaram
Fri Aug 25, 2023 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turn off consolidated drilling?
Replies: 4
Views: 855

Re: Turn off consolidated drilling?

Using element security is an interesting idea, I'll have to try it out. I am trying to display the top and bottom levels of a three tier hierarchy so I would just need to make sure that hiding the middle parents didn't block access to the leaves altogether. Whether this works using element security...
by lotsaram
Fri Aug 11, 2023 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Domain-Administrator for TM1?
Replies: 2
Views: 1136

Re: Domain-Administrator for TM1?

The main issue is access to network resources. The account running the TM1 service doesn't need to be domain admin, but the account needs to have sufficient rights to do what it needs to do, e.g. read from and write to network shared folders which are located on another machine on the network, use t...