Search found 41 matches

by Adam
Thu Feb 25, 2021 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Aggregation problem when linking cubes
Replies: 12
Views: 240

Re: Aggregation problem when linking cubes

I am trying to allocate the count to each raw material in the same proportion that it is used in products. Are these proportions (“recipes”) already defined in TM1 in another cube? (Answer has to be “yes” otherwise you cannot proceed.) You’ll need to reference the proportions there to move the data...
by Adam
Thu Feb 25, 2021 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Aggregation problem when linking cubes
Replies: 12
Views: 240

Re: Aggregation problem when linking cubes

So the source cube has to following dimensions: time, user, product, and, consumption_measures:order_count. The target cube has the following dimensions: time, user, product, raw_materials (the raw materials that goes into each product), and consumption_measures:order_count. What I am trying to do ...
by Adam
Wed Feb 24, 2021 10:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Weird process names
Replies: 5
Views: 199

Re: Weird process names

lotsaram wrote:
Wed Feb 24, 2021 10:11 pm
These are most likely unregistered processes which are created (and destroyed after executing) on the fly.
I’m not familiar with this concept at all. How or when is an unregistered process created?
by Adam
Wed Feb 24, 2021 8:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Aggregation problem when linking cubes
Replies: 12
Views: 240

Re: Aggregation problem when linking cubes

Hi Ahmed, It sounds to me like you're using Performance Modeler. I'm going to surmise your moving from let's say year dimensionality in the source cube to year + month dimensionality in the target cube, am I close? In the target cube, if you have one additional dimension (e.g. month), which element ...
by Adam
Wed Feb 24, 2021 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Weird process names
Replies: 5
Views: 199

Re: Weird process names

In which tool? Workspace? Architect? Performance Modeler? Arc?
by Adam
Wed Feb 24, 2021 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: copying element security data from one element to another
Replies: 8
Views: 252

Re: copying element security data from one element to another

Wim Gielis wrote:
Wed Feb 24, 2021 8:34 am
In Architect/Perspectives, right click the process name and check the Security access.
Hello Ceren. Would you please confirm you did this? Unless you're getting a process error I'm inclined to think this is a problem.
by Adam
Mon Feb 22, 2021 4:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: preventing automatic restart of databases after monthly maintenance
Replies: 14
Views: 212

Re: preventing automatic restart of databases after monthly maintenance

However I doubt that IBM runs its Cloud offerings on Windows... They do run it on Windows server. ------- Like you, we are also IBM Cloud customers and have the same request, Ceren. I reached out to IBM support about a year ago and was told to submit a new enhancement idea, so I did: https://ibm-da...
by Adam
Thu Feb 18, 2021 9:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create MDX View To Suppress Rule-Defined Cells
Replies: 2
Views: 126

Create MDX View To Suppress Rule-Defined Cells

I've spent significant time experimenting, but I cannot figure it out.

Is there a way for me to filter out elements in an MDX View that are rule defined?

Recognize an easy work around would be to create an attribute but was wondering if there’s an automated way.

Thank You!
by Adam
Tue Feb 16, 2021 3:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using parameter to specify CellPutN/S
Replies: 4
Views: 105

Re: Using parameter to specify CellPutN/S

The problem is, taht no matter what parameter I use, I always insert data corresponding to the December. I have no idea why. Wrong Result after spicifying the parameter pVersion to be 9. Hi Vasek, I’m a little confused. You mention the data always shows in December. Then you specify 9 as the pVersi...
by Adam
Fri Feb 12, 2021 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unload cube before changing rules
Replies: 0
Views: 304

Unload cube before changing rules

Learned something today that I figured I would share for people new to TM1. I'm pretty sure the veterans are going to say this is well known, but I still think it's good to document. Everyone's going to come across needing to change rules for an existing cube with data. Historically what I’ve done i...
by Adam
Fri Feb 12, 2021 6:08 pm
Forum: Enhancements
Topic: Shared Sandboxing
Replies: 3
Views: 238

Re: Shared Sandboxing

lotsaram wrote:
Fri Feb 12, 2021 3:50 pm
This was discussed during the AMA on Feb 11th.

The short summary is that it won't be in the v11 server. It is something they will work on after the launch of the v12 "next generation" server.
I think we were all on the same call ... my takeaway was that this is easily 2 years away.
by Adam
Tue Feb 09, 2021 11:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number formatting with dash as zero / DataSpreadFailed
Replies: 0
Views: 87

Number formatting with dash as zero / DataSpreadFailed

Hi friends, My preferred Excel number formatting in everything I do, TM1, Excel, balancing my checkbook, etc. is: In Excel Speak = #,##0;(#,##0);- In TM1 Speak = c:#,##0;(#,##0);- Turns out using a dash as a zero works in all cases in IBM PA for Excel with Quick Reports, with one exception. When wri...
by Adam
Tue Feb 09, 2021 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube Size
Replies: 5
Views: 2581

Re: TM1 Cube Size

We have found this list also includes cubes that are flagged to load on demand. So they should not be consuming any RAM? Or at least very little? I think any detailed analysis on RAM, as you suggest, should be done using performance monitor . It will give you quite granular breakdown. ROT is that T...
by Adam
Fri Feb 05, 2021 11:00 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 15
Views: 16503

Re: PickList to show Alias but store Element Name

Wim Gielis wrote:
Fri Feb 05, 2021 10:36 pm
ppniederbracht wrote:
Fri Feb 05, 2021 9:37 pm
Try: subset:DIMENSION:SUBSET<StoreAlias=F> as picklist definition.
Thanks, nice first post I would say :-) This will be new information to many of us.
I've raised a support ticket w/ IBM to see why this is undocumented.
by Adam
Fri Feb 05, 2021 10:14 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 15
Views: 16503

Re: PickList to show Alias but store Element Name

ppniederbracht wrote:
Fri Feb 05, 2021 9:37 pm
Try: subset:DIMENSION:SUBSET<StoreAlias=F> as picklist definition.
This does actually work. Did a search and it's not in the IBM documentation, and Google search shows a single result from 2016. Thanks for the tip.
by Adam
Mon Jan 04, 2021 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel =SUBNM Limitations
Replies: 2
Views: 369

Excel =SUBNM Limitations

Hello, I was going to ask the question is there a limit to the number of items that can be shown on an Excel SUBNM list . However, I just figured, why don't I try instead of ask. I pointed SUBNM against the longest dimension I have, in this case it's }LineNumber. :D First good news is that it displa...
by Adam
Wed Dec 23, 2020 3:35 pm
Forum: General
Topic: 75,000 posts
Replies: 6
Views: 978

Re: 75,000 posts

...reality is that it's a recognition of all the time and assistance that so many people, both past and present, have invested here over the years. Really well said and I should have said something to that effect. Thank you to you and the rest of the veterans for training us, the next gen of TM1ers...
by Adam
Tue Dec 08, 2020 9:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Throttle and / or Block a users Rest API connection from third party apps.
Replies: 8
Views: 573

Re: Throttle and / or Block a users Rest API connection from third party apps.

I do have a wider concern that this seems to be genuine hole from an InfoSec point of view, it would be extremely difficult / impossible to check if a user who has legitimate access to TM1 was using the RestAPI to pull data and sitting outside of the planning analytics infrastructure. Nefarious use...
by Adam
Thu Dec 03, 2020 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: request for assistance
Replies: 2
Views: 228

Re: request for assistance

...bring the children in with their signs flipped on the cube slice... This is not how it works. If the user entered +15, any display of that cell will show +15. If the user entered -15, any display of that cell will show -15. ...i thought the application would apply the negative -1 weightings... C...
by Adam
Wed Dec 02, 2020 4:14 am
Forum: General
Topic: 75,000 posts
Replies: 6
Views: 978

75,000 posts

Well 75,001 now!

:D