Search found 1385 matches

by Steve Rowe
Sat Jun 16, 2018 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Subset Alias Turned Off After Dimension Rebuild
Replies: 4
Views: 324

Re: Public Subset Alias Turned Off After Dimension Rebuild

I expect the alias is being recreated during the rebuild rather than just refreshed. Look the function attrdelete function and comment it out. If you have used the TI wizard you need to change the settings relating to the attribute.
by Steve Rowe
Tue Jun 12, 2018 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 366

Re: How to reference data lines as variables in TI?

Interesting I had not noticed that issue, though I am nearly always using Expand with text rather than numbers. Thanks for raising. Love the way that IBM document the defect so they don't have to treat it as a defect because it is documented, that seems to be a fairly recent addition to the document...
by Steve Rowe
Tue Jun 12, 2018 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 366

Re: How to reference data lines as variables in TI?

You need to use Expand to translate your string reference to an indirect variable reference. sInputColl = Expand('%Coll' | numbertostring(X) | '%'); #Expand returns a string (or do it all on a single line) nInputColl = StringToNumber(sInputColl); So if Coll10 contain the value 99, when X=10 nInputCo...
by Steve Rowe
Fri Jun 08, 2018 12:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 8
Views: 328

Re: Dimension subset editor in TM1 Perspectives

AS Wim points out this behaviour does vary by version....
by Steve Rowe
Fri Jun 08, 2018 11:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 8
Views: 328

Re: Dimension subset editor in TM1 Perspectives

The other reason that the subnm double click often fails is that people often try and reference another cell to get the server name, this will stop the double click from working.

=Subnm("Server:Dimension",....

works

=Subnm( A1 & ":Dimension",....

will not work
by Steve Rowe
Fri Jun 08, 2018 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking Element Level Security in a TI processes
Replies: 6
Views: 224

Re: Checking Element Level Security in a TI processes

You could take this a step further. 1. Set up a subset that uses the MDX. 2. Create a "Front end cube", dimension by }Clients and a dimension with the various parameters. 3. Give the parameter list a pick list attribute and assign the MDX subsets. 4. Remove the parameter from the TI and read it from...
by Steve Rowe
Thu Jun 07, 2018 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: C Level Rules with attributes evaluations in N level elements
Replies: 5
Views: 252

Re: C Level Rules with attributes evaluations in N level elements

[ 'Capital', 'Real' ] =C: IF ( # With the following 3 lines i am trying to ensure the element for time dimension correspond to the C level element that i need: ( DType ( 'Month', !Month ) @= 'C' ) & ( ElIsAnc ( 'Month', 'QTD', !Month ) = 1) & ( Ellev ( 'Month', !Month ) = 1) # With the folowing 4 l...
by Steve Rowe
Sat Jun 02, 2018 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Invalid string
Replies: 4
Views: 263

Re: Invalid string

This issue often happens because the wizard in the data tab assumes that every field that contains a number is a numeric variable type. So your year field will often end up as a numeric variable. This then causes syntax errors at a later stage.
So check the data tab basically.
by Steve Rowe
Fri Jun 01, 2018 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW / PAX performance discussion
Replies: 6
Views: 538

Re: PAW / PAX performance discussion

Excellent, great news!
by Steve Rowe
Fri Jun 01, 2018 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW / PAX performance discussion
Replies: 6
Views: 538

Re: PAW / PAX performance discussion

Hi Robster,

I've noticed the lag in dragging panes as well. Can I ask if you are using PAW through a RDP session connecting to a remote location? I have found that this seems to be the main contribution to the lag rather than PAW itself?

Cheers,
by Steve Rowe
Fri May 25, 2018 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx and Issues with Excel Status Bar
Replies: 0
Views: 127

PAx and Issues with Excel Status Bar

Hi, We've had a few reports from customers that the status bar in Excel stops working, the piece where you can highlight a cell range and get the sum / count /average and so forth in the bottom right hand corner. I'm sure I saw another posting on here that mentioned it in passing but can't find it n...
by Steve Rowe
Tue May 22, 2018 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 549

Re: Filtered by string measure in a 3 dimension cube

Ohhh that "FIlter by View Extract" :oops:

That doesn't work for me either! You can get pretty close with the ordinary filter button though....
by Steve Rowe
Tue May 22, 2018 9:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 549

Re: Filtered by string measure in a 3 dimension cube

Hi Wim,

See below, you can tell the recorder is on because the Save button is greyed out. I seem to get the same behaviour irrespective of how I access the subset editor or the release
MDX filter record 2.gif
MDX filter record 2.gif (28.48 KiB) Viewed 356 times
MDX filter record.gif
MDX filter record.gif (17.03 KiB) Viewed 356 times
by Steve Rowe
Sun May 20, 2018 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ordering of Dimensions
Replies: 3
Views: 372

Re: Ordering of Dimensions

So the rule of thumb is shortest sparsest to longest and most dense. I don't think that density is as simple as (No of populated cells/ No of N level cells), it is more "if Element 1 is populated, if I keep all the other cell references the same, what is the likelihood of Element 2 being populated a...
by Steve Rowe
Wed May 16, 2018 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 297

Re: Security Access Flag not being Deployed

Not sure if this has changed at some point but I've always had to do this since this bit of logic was introduced. Not sure where the security access state of a TI is stored, I would have though there ought to a }Process_Properties cube somewhere but I've never spotted where. AFAIK the security state...
by Steve Rowe
Tue May 15, 2018 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 549

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 Steve Rowe
Tue May 15, 2018 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 549

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.
by Steve Rowe
Thu May 10, 2018 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube ViewTo Excel/CSV
Replies: 8
Views: 5327

Re: Export Cube ViewTo Excel/CSV

Hmmm, you need to convert each field/column/variable to a string independently, so if you have 5 numeric variables then you'll need to write. AsciiOutput( 'WhyIsThisFunctionNameSoLong.cma' , NumberToString( v1) , NumberToString( v2) , NumberToString( v3) , NumberToString( v4) , NumberToString( v5) )...
by Steve Rowe
Wed May 09, 2018 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 399

Re: stored values in tm1

This issue comes up fairly often and is caused by the floating point arithmetic used by computers in general to store values, simply put not all decimal numbers can be stored exactly in binary leading to very small rounding issues. https://en.wikipedia.org/wiki/Floating-point_arithmetic In this mann...
by Steve Rowe
Thu May 03, 2018 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 2017

Re: PAW installation help

We found that there was a step up in RAM required for PAW to launch in a recent release, previously 8GB was sufficient for the OS and PAW but no longer. We got it to run up on 9 just but would suggest spec'ing a PAW box at 16GB for comfort. We found that installs on W16 with sufficient RAM for docke...