<img src="https://trc.taboola.com/1278851/log/3/unip?en=page_view" width="0" height="0" style="display:none">
finding octane

Enhancing Planning Analytics Workspace (PAW) visualisations using MDX

Comment_Icon_black0
Alarm_Icon_15 min

Planning Analytics Workspace (PAW) offers a robust suite of visualizations, enabling users to create rich and compelling reports and dashboards with remarkable flexibility. However, even with these capabilities, you may occasionally encounter requirements that push the limits of what PAW provides out of the box. One such scenario I encountered was the need to create a column chart comparing Actual vs Budget variance. The twist? Any negative variance should be highlighted with a red bar, while positive variance should be displayed in green, as shown below: PAW’s default settings don't ...

Line_2015

Planning Analytics Workspace Local Distributed

Comment_Icon_black0
Alarm_Icon_12 min

PAW Local Distributed is an upgrade to Planning Analytics Local Workspace that can be deployed in a container orchestration engine using either Docker Swarm by Docker or Kubernetes - an open source by Google, for high availability, fail-over, scalability, and fault tolerance in multiple application servers or virtual or even cloud machines. Architecture: The Planning Analytics Workspace Distributed is run on a Swarm mode by deploying the application on multiple Docker nodes (with unique node ids) also known as Swarm. Docker Engine CLI could be used to create a swarm and deploy and manage the ...

Line_2015

Views integration in PAX and PAW

Comment_Icon_black0
Alarm_Icon_13 min

In the latest version of PAX (2.0.44) as well as PAW (2.0.44), IBM has added a new capability to allow the views to be shared between PAW and PAX using Planning Analytics Workspace Content Store. What does this mean for us? We can now save the views in content store and share it across to be accessed from either PAW or PAX which was not possible earlier. This further strengthens the integration and make the PAX and PAW interoperation even more seamless which a good step as far as usability and software portability is concerned. Steps to access the views from PAW content store from PAX: We ...

Line_2015

PAX and PAW 2.0.41

Comment_Icon_black0
Alarm_Icon_13 min

What's interesting to note is that Planning Analytics Workspace (PAW) version 2.0.40 and 2.0.41 are combined so that the release of Planning Analytics Workspace 2.0.41 aligns with the IBM Planning Analytics for Microsoft Excel (PAX) release. With several fixes applied to both PAW and PAX in this version; this post will focus more on the enhancements and features. However, should you want to review the fixes, you can find those here. Features: With this release, you will now be able to create and edit drill through rules and processes in Workspace. Also finding users who don't have any ...

Line_2015

Unraveling TM1 : Lesser Known Facets – Part B

Comment_Icon_black0
Alarm_Icon_17 min

Thank you if you have come back for more! Hope our last blog Unraveling TM1 : Lesser Known Facets – Part A was meaningful. In this part we will unearth & explore few more of these lesser known gems. As always, if you like what we do and want to associate; subscribe to our Blogs at http://blog.octanesolutions.com.au Function TM1RPTROW We know TM1RPTROW is a salient function when building demand and rolling forecasts in Planning and Budgeting models Although everyone is aware of the fact that parameters like Dimension Subset, MDX Expressions are a part of TM1RPTROW, developers tend to ...

Line_2015

Unraveling TM1 : Lesser Known Facets – Part A

Comment_Icon_black0
Alarm_Icon_16 min

No matter how much we think we know about TM1, there are always these set of conditions that make you think “what-if there was a better way”??!! For example, not having to write a bunch of codes just to delete the subsets after using it in a Source View Or not writing the same area definition twice. What-if this could be done with less or no coding at all! This blog and its subsequent part will focus on showcasing few of such many lesser known features in TM1. These little tricks and tips are a step towards better code management and of course peace of mind. TIP 1. One area definition for two ...

Line_2015

Caveat Around Concurrent Data Loads - Part B

Comment_Icon_black0
Alarm_Icon_14 min

Welcome back, for those who had read Part A of this blog, hope you would have tested Parallel Interaction and benefitted from it. For those who haven’t, you can read it at http://blog.octanesolutions.com.au/caveat-around-concurrent-data-loads-part-a This blog builds upon the previous one and focusses on improving performance by Parallel Interaction, it highlights TM1 facets worth consideration while an object is locking. Synopsys Tips towards improvements around support for concurrent read/write and/or parallel execution of turbo integrator process enabling higher efficiencies and ...

Line_2015

Sandbox Analysis. Delivered

Comment_Icon_black0
Alarm_Icon_15 min

In this blog, would like to introduce you to a new feature called "Compare Sandboxes"; this feature, an extension to Planning Analytics Workspace’s existing capability, shall be available both on Cloud and in Local versions. What is a Sandbox? (Jump to “Feature Explained” section if you are an existing TM1 user & know this well) A Sandbox lets you create your own personal workspace, your own version where you can enter & store data-value-changes without impacting the base (actual) data. A sandbox is not a copy of the base data, but a separate overlay or a layer of your own data values ...

Line_2015

IBM PA Workspace Installation & Benefits for Windows 2016

Comment_Icon_black0
Alarm_Icon_18 min

In this weeks blog, our team make it our duty to shine some light on right tool your company can choose to meet your business needs. We will cover the much discussed benefits of installing and using IBM's Planning Analytics workspace on Windows 2016. Contents What is PA and PAW PAW and Windows 2016 Benefits on PAW on Windows 2016 What is PA and PAW? Planning Analytics ("PA") is the next version, or can be considered as the next generation of TM1. IBM enhanced TM1 functionality and features and embraced new tools to its' suite. This new enhanced TM1 has been rebranded as PA. IBMs PA has the ...

Line_2015