Search found 1513 matches

by Steve Rowe
Fri Oct 04, 2019 3:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create elements based on a cubeview
Replies: 2
Views: 215

Re: Create elements based on a cubeview

You need to limit your datasource to just the element name and then use CellGetS to ElementDetails to lookup the other values you are after. i.e. Row 1 of your DS "Dimension", "Account","10-04-27" sParentElement= CellGetS ( 'ElementDetails' , vDimension , vAccount ,'ParentElement'); I think...it's n...
by Steve Rowe
Fri Oct 04, 2019 3:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 390

Re: Different rules for same element in different hierarchies

:lol: My golden rule, never answer a forum post before two cups of coffee!
by Steve Rowe
Fri Oct 04, 2019 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 390

Re: Different rules for same element in different hierarchies

I don't think what you want to do is possible, the N level of a cube is common for all hierarchies.

C levels are different, same named C level members in different hierarchies are distinct members.
by Steve Rowe
Thu Oct 03, 2019 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Action button - call Macro
Replies: 10
Views: 413

Re: Tm1 Action button - call Macro

If you are using PA for Excel then (your opening posts looks like PA for Excel but later you say Perspectives) https://ibm.github.io/paxapi/#introduction If you are using Perspectives then you can write calls using the old API but it is much much more involved. You may find some good material with s...
by Steve Rowe
Fri Sep 27, 2019 9:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Continuous time link to discrete time dimension
Replies: 8
Views: 267

Re: Continuous time link to discrete time dimension

WayneBo wrote:
Fri Sep 27, 2019 6:42 am

Is there a way that I can mass edit the attributes of a dimension after the dimension been created already?
Use a TI process to with the a level zero subset of the dimension as a datasource and write the attribute to the dimension
or
use the DBSA formula to write the value from Excel
by Steve Rowe
Fri Sep 06, 2019 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application.Run("DBRW"...) RECALC_0_3 in Worksheet_Change
Replies: 4
Views: 536

Re: Application.Run("DBRW"...) RECALC_0_3 in Worksheet_Change

Is it possible that your "confusing" Excel and the TM1 client?

Your worksheet change macro does not include disabling of events and so could be getting triggered multiple times.
by Steve Rowe
Wed Aug 14, 2019 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Workspace BOOK
Replies: 4
Views: 1463

Re: Copy Workspace BOOK

Hi, The buttons are not that clear. Import - means load the .gz into the Lifecycle Management environment. Migrate - means place the objects that I have imported into the PAW environment I have selected. At this point you will be asked for a folder name. Once the objects are migrated they will appea...
by Steve Rowe
Thu Aug 01, 2019 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Installation Crashes
Replies: 3
Views: 358

Re: Local Installation Crashes

Hi, Can you be explicit about the "crash" behaviour? Do you mean user gets bored waiting and kills Excel or an actual crash?
by Steve Rowe
Wed Jul 31, 2019 11:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 612

Re: Server crashing with "Evalution stack overflow"

Hi, In my experience on the versions where I had models with this issue my approach is as follows. (I'm qualifying this because the behaviour has been different in different releases and I've not had a model like this in recent builds). I _think_ the stack is 2^9 =512, therefore reset every 500 "ste...
by Steve Rowe
Tue Jul 30, 2019 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crashing with "Evalution stack overflow"
Replies: 10
Views: 612

Re: Server crashing with "Evalution stack overflow"

Hi, If you move the rule sheet for the problem cube then your server will start, with PersistentFeeders=F. This issue normally happens when you feed forward over time, i.e. todays opening balance to tomorrows closing balances. See this thread for more detail https://www.tm1forum.com/viewtopic.php?f=...
by Steve Rowe
Fri Jul 26, 2019 8:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW formula works for development server but not for production server
Replies: 6
Views: 4026

Re: DBRW formula works for development server but not for production server

This should be a simple issue. I'd try the DBRW in totally fresh session versus the live server, rather than switching admin servers and relogging. My best guess from your screen shot is that one of the cell references is not evaluating properly when the DBRW calcs since the DBRW is returning #Value...
by Steve Rowe
Fri Jul 26, 2019 7:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW formula works for development server but not for production server
Replies: 6
Views: 4026

Re: DBRW formula works for development server but not for production server

Are your development TM1 database and your production database called the same thing?
by Steve Rowe
Tue Jul 23, 2019 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Statsby Rule Cube
Replies: 2
Views: 793

Re: Statsby Rule Cube

IMO Total Run Count should be 6 as these are the only cells that are fed. But this would be if A. This is the first time the rule has been calculated B. None of the cells that are currently zero had previously had a number in it prior to the rule being calculated, this would mean that some of the ze...
by Steve Rowe
Thu Jul 18, 2019 8:37 am
Forum: Bugs
Topic: PAx DBRW type over failure
Replies: 0
Views: 4714

PAx DBRW type over failure

This impacted 2.0.42 with CAM log ins. (not tested if it happens in mode 1) When entering a number over a DBRW the formula was being over written by a value. Cause. On first log-in the issue did not show. If you close Excel and attempt to log back in you are not asked to re-authenticate but automati...
by Steve Rowe
Thu Jul 18, 2019 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx, authenticating with CAM and mutiple instances
Replies: 2
Views: 856

Re: PAx, authenticating with CAM and mutiple instances

This was resolved by moving to the latest versions of PAx and the TM1 DB and using the newish PMHubless connection.
by Steve Rowe
Thu Jul 18, 2019 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX has blank task pane
Replies: 5
Views: 964

Re: PAX has blank task pane

I think happens because you have pointed PAx at the TM1 server not the PAW server, without the PAW sever the "web" stuff doesn't work.

Also make sure you have IE11 on the client machine.

EDIT : See below, it's what JorelB says
by Steve Rowe
Thu Jul 18, 2019 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Occasionally stuck making ODBC connection
Replies: 5
Views: 382

Re: Occasionally stuck making ODBC connection

Hi, In my experience this usually happens because the destination server is locked performing some kind of major activity. Though you've checked to see if the connection is made is there any reason Netezza would be refusing the connection or locked in some way? I'm not aware of any to test if the co...
by Steve Rowe
Thu Jul 04, 2019 10:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 382

Re: Feeder statement cleanup

Wow, we're all up late!
by Steve Rowe
Thu Jul 04, 2019 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 382

Re: Feeder statement cleanup

If you've done a major rewrite then I'd suggest deleting all feeder files with the server shut down. It will sort itself out on start-up.