Search found 1655 matches

by Wim Gielis
Tue May 22, 2018 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 258

Re: Filtered by string measure in a 3 dimension cube

I think we speak of different things.

There is Filter in the Tools menu, and Filter by view extract.

The first is possible when an expression is recorded (and can be useful), the second one is not enabled (too bad).
by Wim Gielis
Tue May 22, 2018 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 258

Re: Filtered by string measure in a 3 dimension cube

Hi Wim, I do this a lot to get the base form of the MDX that I want to use in active forms or elsewhere so it is very much possible. Maybe one of those things that was not available on first release and you've not revisited? That happens to me, small change that I've not picked up on, or maybe just...
by Wim Gielis
Tue May 22, 2018 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)
Replies: 2
Views: 29

Re: MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)

For example,

Code: Select all

{FILTER({Subset ( {TM1FilterByLevel(TM1SubsetAll ( [Kund] ) , 2)}, 11, 10)}, [Test].([Posting Measures].[Amount]) > 0 )}
and you will want to restrict the selection in the Test cube more such as to come to the desired results. Select in the cube on year, period, scenario, ...
by Wim Gielis
Tue May 22, 2018 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block TM1 usage during upgrade / migration
Replies: 3
Views: 95

Re: Block TM1 usage during upgrade / migration

Hi all,

Thanks, that gives food for thought.

I think I will make the users read only (}ClientProperties cube, ReadOnlyUser = 1).
Next to that, process security can be set to NONE in a rule.
It's CAM security.

Many thanks,

Wim
by Wim Gielis
Mon May 21, 2018 7:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block TM1 usage during upgrade / migration
Replies: 3
Views: 95

Block TM1 usage during upgrade / migration

Hello, The question might have been asked in the past, I could not find any topics and no luck with Google either. If we migrate TM1 objects from development to production, is there any way to block users from logging in ? Users know that the application is down for maintenance but still they could ...
by Wim Gielis
Thu May 17, 2018 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 252

Re: PAW - missing dimensions and processes

Hi, It’s solved. George is right, the first user created becomes administrator. Apparently the customer had deleted this first user, and then the administrator role goes to the user that was created second. The user that was used for the screenshot did not have the administrator rights. Thanks to th...
by Wim Gielis
Thu May 17, 2018 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 252

Re: PAW - missing dimensions and processes

I have the same when I log on to PAW systems in the cloud (IBM cloud concierge). Then I see all nodes.
In this instance, the sceenshot is as shown.

I will get back to you Edward when I get the information, thanks.
by Wim Gielis
Thu May 17, 2018 10:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 252

Re: PAW - missing dimensions and processes

Hi Edward,

Yes, PAW Local (on premise).

The user is a member of the Admin group in TM1.
by Wim Gielis
Thu May 17, 2018 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - missing dimensions and processes
Replies: 11
Views: 252

PAW - missing dimensions and processes

Hello all, I encounter an issue with PAW, being that in the navigation pane for Applications, Cubes, Dimensions, Processes, Dimensions and Processes and control objects are missing: only applications and cubes.jpg Is this a setting that we can/should change, or more likely to be an installation issu...
by Wim Gielis
Wed May 16, 2018 10:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfer data within cubes for a particular month and future set of months in a year
Replies: 12
Views: 515

Re: Transfer data within cubes for a particular month and future set of months in a year

Hello,

Posting an update after only 15 hours can be too optimistic. We are all volunteers helping other lab when there is time.

Wim
by Wim Gielis
Tue May 15, 2018 8:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 258

Re: Filtered by string measure in a 3 dimension cube

If you still have access to the Perspectives subset editor then you can record the MDX for what you want by turning the recorder on and then using the filter dialogue. Hi Steve, AFAIK you cannot record an expression when you filter on view extract. The icon is greyed out. Or did you mean something ...
by Wim Gielis
Sat May 12, 2018 9:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfer data within cubes for a particular month and future set of months in a year
Replies: 12
Views: 515

Re: Transfer data within cubes for a particular month and future set of months in a year

2. The zero out view and source view will both need a subset containing the correct month(s), like you described. You can choose to create 12 subsets manually and thus reduce the coding. If you do it wisely, you could deduct the subset name from the pMonth parameter that the user fills in. If you pr...
by Wim Gielis
Sat May 12, 2018 7:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfer data within cubes for a particular month and future set of months in a year
Replies: 12
Views: 515

Re: Transfer data within cubes for a particular month and future set of months in a year

1. Definitely. Since you don’t know upfront where the data will be in the source cube and data can change from one intersection to another, a zero out is needed.
by Wim Gielis
Sat May 05, 2018 8:24 pm
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 19831

Re: Copying Data from 1 Element to Another via TI

If I can get a blog or an article from A - Z or if you can help to understand and Implement this type of process because all posts I saw written from the end not from the beginning. Lotsaram pointed you to a generic TI process (Bedrock.Cube.Data.Copy in Bedrock). Please go there and dissect the cod...
by Wim Gielis
Thu May 03, 2018 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 478

Re: Cube Copy TI Process

Tom is right. I use code like this:

Code: Select all

sMDX = '{TM1FILTERBYLEVEL(DESCENDANTS([Month].[' | pMonth | ']), 0)}';
by Wim Gielis
Thu May 03, 2018 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1
Replies: 14
Views: 432

Re: tm1

venureddy wrote:
Thu May 03, 2018 9:23 am
Tq. But tym of execution is becoming hard for me
What does this mean ?
by Wim Gielis
Wed May 02, 2018 3:55 pm
Forum: Enhancements
Topic: Determine whether a TI process exists
Replies: 9
Views: 3573

Re: Determine whether a TI process exists

Follow up: ProcessExists has been added recently to the TI functions. Thank you IBM. It would be nice if they also added a TI Function to delete a TI Process (such as ProcessDestroy or ProcessDelete). I have some TI Processes that their names start with } (like control objects) and they cannot be d...
by Wim Gielis
Mon Apr 30, 2018 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add attributes to control dimension
Replies: 9
Views: 369

Re: Add attributes to control dimension

Can you describe in words where the picklist values should come from ?

A guess: if Attribute-AcqType-All is a dimension name, then replace :: with :