Search found 3503 matches

by lotsaram
Mon Mar 13, 2023 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 how to copy private view from one user to another user?
Replies: 5
Views: 1069

Re: tm1 how to copy private view from one user to another user?

There is also the TI function PublishView. You could just let the user run the bedrock view publish process
by lotsaram
Thu Mar 02, 2023 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules with virtual hierarchies
Replies: 10
Views: 1959

Re: Rules with virtual hierarchies

Excellent. Thanks for the update! Glad that you got it to work.

The real code rather than the pseudo code makes it much easier to see.
by lotsaram
Thu Mar 02, 2023 4:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewSubsetAssign - what am I doing wrong?
Replies: 15
Views: 2540

Re: ViewSubsetAssign - what am I doing wrong?

Good points, @Maren - but I was following the conventions set out by our software developer consultant (who we are no longer getting help from) and they haven't thrown up issues before. With all due respect to your former developer. If their advice and "best practice" was to create perman...
by lotsaram
Thu Mar 02, 2023 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help with a feeder
Replies: 9
Views: 1333

Re: Need Help with a feeder

As David Usherwood is now enjoying retirement I can only repeat the point he has made countless times on this forum; the purpose of feeding is for consolidation ergo if a rule calculated measure doesn't need to consolidate then don't feed it. Rates are such a measure, you shouldn't feed rates.
by lotsaram
Tue Feb 28, 2023 11:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules with virtual hierarchies
Replies: 10
Views: 1959

Re: Rules with virtual hierarchies

RFAG #5 Post the actual code! https://www.tm1forum.com/viewtopic.php?t=1037 Show the actual rule that isn't working, not just a snippet. Show the WHOLE rule, including the left hand side. Show the structure of BOTH cubes. If you want help, put in the required minimum effort that people can actually ...
by lotsaram
Tue Feb 28, 2023 8:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules with virtual hierarchies
Replies: 10
Views: 1959

Re: Rules with virtual hierarchies

Did you create a hierarchy? Becasue from the picture you included it doesn't really look like it. It isn't enough to have an attribute in Product dimension matching an element name in Product_Dashboard dimension - you must have a consolidation which exactly matches the name.
by lotsaram
Mon Feb 27, 2023 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating TI Process by running a TI Process
Replies: 4
Views: 1062

Re: Creating TI Process by running a TI Process

I don't really have anything to add to Wim's already excellent post except to emphasize that creating a new process each time you want to load data from one cube to another seems like a very odd thing to do. Much better to simply have a generic process to do this job.
by lotsaram
Wed Feb 22, 2023 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel Calc Issues
Replies: 3
Views: 786

Re: TM1 Excel Calc Issues

When I connect to TM1 via excel, I am getting a RECALC error when I try to refresh my DBRW formulas. I have the add-ins, have tried DBR and DBSW formulas but it still is not working. Any ideas? Thank you If you are using Perspectives this is normally caused by linking a DBRW formula to another DBRW...
by lotsaram
Thu Feb 09, 2023 5:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy security update require a call to SecurityRefresh Function
Replies: 7
Views: 1206

Re: Hierarchy security update require a call to SecurityRefresh Function

I tried the CellPutS but the trick didnt work. :-( Maybe also try CellPutS to the element security cube. What George said rang a bell and I think I can recall needing to do this. (Why I don't know becasue AFAIK ElementSecurityPut should alone be adequate). HierarchyElementSecurityPut(sElSecurity, p...
by lotsaram
Thu Feb 09, 2023 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy security update require a call to SecurityRefresh Function
Replies: 7
Views: 1206

Re: Hierarchy security update require a call to SecurityRefresh Function

I agree this sounds strange. If element security cubes don't contain rules then the ElementSecurityPut function should be sufficient to update security without needing a SecurityRefresh.
by lotsaram
Mon Feb 06, 2023 7:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why transaction logs are only available in Architect ?
Replies: 3
Views: 1106

Re: Why transaction logs are only available in Architect ?

At least as far as Arc goes you can raise a feature request
by lotsaram
Fri Feb 03, 2023 8:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why transaction logs are only available in Architect ?
Replies: 3
Views: 1106

Re: Why transaction logs are only available in Architect ?

If you want to expose transaction logs to non-admin users then you have no alternative but to do the work yourself and load the transaction logs into another database which users have access rights to becasue non-admin users don't have access to transaction logs via rest API (or process error logs f...
by lotsaram
Wed Jan 25, 2023 8:36 am
Forum: Enhancements
Topic: Python Integration PA on Cloud
Replies: 4
Views: 8219

Re: Python Integration PA on Cloud

Where is the like button?
by lotsaram
Fri Jan 20, 2023 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: quote issue on a MDX TurboIntegrator function
Replies: 7
Views: 2844

Re: quote issue on a MDX TurboIntegrator function

+1 I would also always use Expand for such cases. It's just easier.
by lotsaram
Mon Jan 16, 2023 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading data from source cube to target cube with the source cube bigger in dimensionality
Replies: 3
Views: 823

Re: Uploading data from source cube to target cube with the source cube bigger in dimensionality

There is a bedrock process which can do this task without writing any code. }bedrock.cube.data.copy.intercube
by lotsaram
Thu Jan 12, 2023 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess
Replies: 2
Views: 702

Re: RunProcess

I think you might be confusing RunProcess (runs in parallel on a new thread in new transaction) with ExecuteProcess (runs in serial in same thread in same transaction). If you want the calling process to wait for the sub-process and easily read the status of the sub-process then using ExecuteProcess...
by lotsaram
Mon Jan 09, 2023 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on this MDX
Replies: 11
Views: 1333

Re: Need help on this MDX

It seems that both Subset1 and Subset2 already exist.

Here pseudo-code is not your friend. Please provide the actual code! Otherwise no one can tell what you are actually querying as the pseudo code is so far off the mark that I don't even know where to start.
by lotsaram
Wed Jan 04, 2023 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Source cube view optimization in TI
Replies: 15
Views: 1521

Re: Data Source cube view optimization in TI

Well first you can make sure that your instance is using MTQ, e.g. MTQ= -1 ot MTQ = All to use all cores, MTQ = -2 to use all cores except 1 or MTQ = 16 to use just 16 cores (assuming the server has more). In all my experience even on big servers and big data models there hasn't ever been a performa...
by lotsaram
Fri Dec 23, 2022 5:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Variables wrongly assigned in PAW
Replies: 8
Views: 1229

Re: TI Variables wrongly assigned in PAW

The problem will be that you're creating the view in Workspace. All views in vorkspace are per definition MDX views. MDX views assign index order of variables based on the view structure . 1st column dimensions (MDX axis 0), then row dimensions (MDX axis 1), then slicer dimensions. So if you constru...
by lotsaram
Thu Dec 15, 2022 5:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias doesn't work in rule right hand side
Replies: 4
Views: 1748

Re: Alias doesn't work in rule right hand side

What he said.

It doesn't matter if an area statement on the LHS uses an alias, when !dimension is used on the RHS it will always evaluate as the principal name. This is how it has always been and will always be.

At least you understand that using aliases on the LHS is a bad idea. Don't do this.