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

Srinivas is TM1 Consultant at Octane Software Solutions and has over 12 years’ experience in Data Warehousing, OLAP & Business Analytics dealing with Hyperion Suite, Cognos BI, ODI and OBIEE technologies. Srini has worked with Credit Suisse Bank, Deutche Bank, Citi Bank, Oracle financial services, McAfee and HCL Technologies before joining Octane.
arrow

Planning Analytics Administration: An Alert (Proactive Mechanism)

Comment_Icon_black0
Alarm_Icon_13 min

Gone days, where we had no control/alerts mechanism on the TM1 database, CPU/memory it consumes, react at the nick of the moment before TM1 server crashes. I am sure all TM1 lovers, administrators and business users who had these experiences in the past would connect to what I am referring to. For all new Planning Analytics users, in earlier versions of TM1/ Planning Analytics, we had little overview on how much on RAM/ memory can a TM1 instance use/utilize or have an inbuilt alter mechanism. TM1 Database Alert Mechanism: Issue: Most of you know, TM1 Server loves memory/RAM, more memory ...

Line_2015

Potential Data Loss: Quick Fix a must : PA Cloud and PA Local

Comment_Icon_black0
Alarm_Icon_15 min

IBM has identified a defect within the code introduced in TM1 10.2.2 Fixpack 7, part of all other releases before 2.0.9. This defect causes data loss within the cubes even after performing SaveDataAll activity with in TM1 server. Let us get into the details. What is the defect : Possibility of losing data even after SaveDataAll activity is performed. This defect (APAR PH19984) has been identified recently by IBM. This will only trigger when below conditions are met. No-SaveDataAll : If SavedataAll not performed since TM1 Server was rebooted. Lock Contention : Lock contention specific to ...

Line_2015

Planning Analytics for Excel: Trace TI status

Comment_Icon_black0
Alarm_Icon_12 min

IBM has been recommending its users to move to Planning Analytics for Excel (PAX) from TM1 Perspective and/or from TM1 Web. This blog is dedicated to clients who have either recently adopted PAX or contemplating too and sharing steps on how to trace/watch TI process status while running process using Planning Analytics for Excel. Steps below should be followed to run processes and to check TI process status. 1. Once you connect to Planning Analytics for Excel, you will be able to see cubes on the right-hand side, else you may need to click on Task Pane. 2. Click on the middle icon as shown ...

Line_2015

PA+ PAW+ PAX (Version Conformance)

Comment_Icon_black0
Alarm_Icon_15 min

IBM, with the intention of adding new features to Planning Analytics ( TM1) and to its Visualization and reporting tools Planning Analytics Workspace and Planning Analytics for Excel new release are happening at regular intervals. New version for Planning Analytics Workspace, Planning Analytics for Excel comes out every 15-40 days, for Planning analytics new version comes out every 3-6 months. In this blog, I will be discussing about the version combinations to be used between these tools to get better/optimum results in terms of utilization, performance, compatibility and bugs fixes. ...

Line_2015

Planning Analytics Secure Gateway: Token Expiry

Comment_Icon_black0
Alarm_Icon_13 min

Before you read further, please note, this blog details secure Gateway connection used for Planning Analytics deployed “on-cloud” Software as a Service (SaaS) offering. This blog details steps on how to renew secure gateway Token, either before or after the Token has expired. What is IBM Secure Gateway: IBM Secure Gateway for IBM Cloud service provides a quick, easy and secure solution for establishing link between Planning Analytics on cloud and a data source; Typically, an RDBMS source for example IBM DB2, Oracle database, SQL server, Teradata etc. Data source/s can reside either ...

Line_2015

IBM Planning Analytics for Excel: Bug and its Fix

Comment_Icon_black0
Alarm_Icon_15 min

Since the launch of Planning Analytics few years back, IBM has been recommending its users to move to Planning Analytics for Excel (PAX) from TM1 Perspective and TM1 Web. As every day new users migrate to adopt PAX, it’s prudent that I share my experiences. This blog will be part of a series where I would try to highlight and make users aware of different aspects of this migration. This one specifically details a bug I encountered during one of the projects in which our Clients was using PAX and steps taken to mitigate the issue. What was the problem: Scenario: when a Planning Analytics User ...

Line_2015

IBM Planning Analytics Secure Gateway Client: Steps to Set-Up

Comment_Icon_black0
Alarm_Icon_17 min

This blog broaches all steps on how to install IBM Secure Gateway Client. IBM Secure Gateway Client installation is one of the crucial steps towards setting up secure gateway connection between Planning Analytics Workspace (On-Cloud) and RDBMS (relational database) on-premise or on-cloud. What is IBM Secure Gateway : IBM Secure Gateway for IBM Cloud service provides a quick, easy, and secure solution establishing a link between Planning Analytics on cloud and a data source. Data source can reside on an “on-premise” network or on “cloud”. Data sources like RDBMS, for example IBM DB2, Oracle ...

Line_2015

Planning Analytics - Cloud Or On-Premise

Comment_Icon_black0
Alarm_Icon_14 min

This Blog details IBM Planning Analytics On-Cloud and On-Premise deployment options. It focusses & highlights key points which should help you make the decision; “whether to adopt Cloud Or stay on Premise” IBM Planning Analytics: As part of their continuous endeavour to improve application interface and better customer experience, IBM rebranded TM1 to Planning Analytics couple of years back which came with many new features and a completely new interface. With this release (PA 2.x version as it has been called), IBM is letting clients choose Planning Analytics as Local SW or as Software ...

Line_2015

Support & Dev – Sorry no more : TM1 10.2.x

Comment_Icon_black0
Alarm_Icon_14 min

Yes .. You read it right !! … IBM is ready to start “End of Support” for TM1 10.2.x version by 30th September 2019. IF you are a User / Owner / Stakeholder of any application which is on TM1 10.x versions then yes this would mean an immediate attention needed and would need necessary action. What does End of Support Mean ? Though End of Support (EoS) doesn’t mean your application will stop functioning but involves other risks. Few are listed below. No further development to this version. No further enhancement happening to this version.. No bug fixes. No new code updates. No more Standard ...

Line_2015

Predictive & Prescriptive Analytics: IBM Decision Optimisation

Comment_Icon_black0
Alarm_Icon_17 min

Predictive analytics: Predictive analytics is the practice of extracting information from existing data sets in order to determine patterns and predict future outcomes and trends. A way to predict the future using data from the past. Predictive analytics brings together advanced analytics capabilities spanning ad-hoc statistical analysis, predictive modelling, data mining, text analytics, optimization, real-time scoring and machine learning. These are tools that help organizations discover patterns within the data and go beyond knowing what has happened to anticipate what is probable to ...

Line_2015

Business Intelligence – Business Analytics

Comment_Icon_black0
Alarm_Icon_18 min

This article talks about Business Intelligence and Business Analytics, things in common and about differences between one another. This blog also talks about the paybacks for an organization once these are adopted. Let’s start ... Though Business Intelligence and Business Analytics sound similar and are being used interchangeably by many, they do have differences. Business Intelligence ( BI ) :- Term Business Intelligence, though exist for long, have been used by wider audience from late 90s . Intelligence with in Business comes from the data being captured. Business Intelligence has been ...

Line_2015

Still on TM1 10.2.X? – Urgent fix is a must

Comment_Icon_black0
Alarm_Icon_16 min

You heard it right – Is your organisation still on TM1 10.2.X and haven’t upgraded to PA? If yes, this is the blog for you as your existing TM1 application is prone to Multiple Security Vulnerabilities … Blog tries to reflect upon the cause and effect of the issue/s, possible interim remediation plan/s and the foolproof solution. Security Vulnerabilities Customers who are still using the IBM Cognos TM1 10.2 and IBM Cognos TM1 10.2.2 are prone to unauthenticated attacks, excessive stack memory issues and other threats. Listed below are the security Vulnerabilities; OpenSSL could allow a remote ...

Line_2015

Planning Analytics 2.0.5 : All you need to know!

Comment_Icon_black0
Alarm_Icon_14 min

IBM has recently launched its Planning Analytics version 2.0.5 (on 25th June 2018); this article captures highlights of what’s new, improved and denounced. New / Improved/ Deprecated Features & Fixes: - New: Planning Analytics Administration agent. Totally new, part of IBM’s strategy to brand PAW as a Single interface for all types of users. In this release, once PAA agent has been configured, it enhances Planning Analytics Workspace user’s interaction with metadata and data. Helps users to drag and drop dimension members to achieve new Dimensions, Attributes. Users can drag and drop ...

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

Little known TM1 Feature - Ad hoc Consolidations

Comment_Icon_black0
Alarm_Icon_14 min

In this blog, let me explain you about one of the hidden/unused feature from IBM Cognos TM1. Before we start, let me ask you a question - Have you ever come across below requirements or related issues while working with TM1? Urgent requirement - Management needs new consolidation within a Canned report to meet their business needs. An Ad hoc requirement from business to get new consolidation member at the earliest. An alternative roll-up request from the Boss - for a better analysis using existing data. Stakeholders request to have additional consolidations which may be part of ad hoc ...

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

IBM TM1 10.2 vs IBM Planning Analytics

Comment_Icon_black0
Alarm_Icon_14 min

Loss vs Gain? As we know – one thing that is constant is change and in the technology the change is always for the advancement from current and improvising the existing features. IBM has made significant changes to its Financial Performance Management product and has rebranded TM1 to IBM Planning Analytics. Rebranding TM1 to Planning Analytics does not mean you are going to lose existing tools like Architect, TM1Web, Perspective, Performance modular, Insight etc. IBM has enhanced the existing tools and improvised them. Few among many are listed below. The Cognos TM1 Web UX is totally ...

Line_2015