Ask a question
Nominate for the IBM Champions program by 15 November!
See attachment. ------------------------------ Nick Plowden AI Community Engagement IBM ------------------------------
Try creating a separate workbook , import the BAS and code etc and run from there Without getting into this too much you are creating a new instance of Excel ( You already have one open) and then trying to open the current open workbook. You would ...
Hi, I am trying to run the below VB script to automate the refresh for my PAX template in C:\Book1.xlsm where I have simple DBRW formulas to pull the data. I have imported the required .bas and .cls files in C:\Book1.xlsm and saved it. ' ...
Hello Scott, Correct. However, this applies then to all cubes in the TM1 database, and hence for all widgets. To me, this seems to be too broad because in certain cubes, or widgets, I can imagine that overwriting a 0 at consolidated levels does not ...
Hi, At a system level, there is a configuration to turn off allowing entry to consolidations that are zero. Administration->Databases-><Particular Database>->Configuration->Modeling->Spreading ProportionSpreadToZeroCells* Allows you to perform ...
Hello Stuart, This new option is definitely useful and makes it safer. What I would think is even more safe, is blocking input on 0's at consolidated levels. If that could be specified on a widget by widget basis, or on a cube basis if needed, ...
Meet Catherine Grainger, the Planning Practice Director at Sempre Analytics. Catherine has worn many hats throughout her career, from management accounting to Head of People. O ne thing she has always come back to is business analytics – whether ...
The IBM Planning Analytics on Cloud team is announcing a change to the original schedule for Rich Tier Removal. The date is now November 16th 2024 (to coincide with November monthly maintenance) for removal of all Rich Tier desktops. You ...
Hello all ! 😊 When you support IBM PAW environments, or your PAW environments are hosted there, it might come in handy to count both the PAW subscriptions and the PAW roles, as well as the TM1 group memberships. Not to mention the TM1 ...
Ann-Grete Tan, (also known as A.G.) is a Principal at Tensor Research. As an IBM Champion for four years, A.G. has consistently demonstrated her commitment to promoting IBM Planning Analytics and fostering a better understanding between technology ...
In this part we will look at using some of the Time Series functions allowing us to create views with Year-on-Year comparisons, rolling averages, moving sums etc. Configure Level Names Level names give you the ability to reference levels within ...
There was a scenario where business is using sandboxes in Tm1 and building multiple scenarios with their plan, and a few users wanted a way to share their plan for a product with multiple scenarios without committing to the base forecast or exporting ...
Watch Now On-Demand