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

Blog

Merging multiple Dynamic Reports in PAfE using Power Query

[fa icon='calendar'] February 11, 2021 / by Amin Mohammed posted in Power Query

[fa icon="comment"] 0 Comments

Ever wondered how good it would have been to merge multiple dynamic reports next to each other for doing your analysis from disparate reports, only to be realise that it can’t be possible?

Read More [fa icon="long-arrow-right"]

Dynamic Arrays and Its Impact on Planning Analytics for Excel

[fa icon='calendar'] February 5, 2021 / by Amin Mohammed posted in Planning Analytics, Excel, Dynamic Arrays

[fa icon="comment"] 0 Comments

In my previous blog articles, I have covered various use cases of Dynamic Arrays(DA) and some of the capabilities it offers.

Read More [fa icon="long-arrow-right"]

TM1 Rest API: Dimensions Metadata Extract

[fa icon='calendar'] October 9, 2020 / by Vamshi Krishna G posted in TM1 How To, PAW and PA

[fa icon="comment"] 0 Comments

Read More [fa icon="long-arrow-right"]

Backup and Restoration PAW- Dashboards, Workbooks and views

[fa icon='calendar'] October 8, 2020 / by Alpheus Dominic

[fa icon="comment"] 0 Comments

 

Read More [fa icon="long-arrow-right"]

Biggest release since 2015 - Planning Analytics Workspace 2.0.57 - 2 October, 2020

[fa icon='calendar'] October 6, 2020 / by Amendra Pratap posted in TM1, PA Workspace

[fa icon="comment"] 0 Comments

 

Read More [fa icon="long-arrow-right"]

Data Analysis using Dynamic Array formulas

[fa icon='calendar'] September 17, 2020 / by Amin Mohammed posted in TM1 How To, TM1 Websheet Form, IBM Planing Analytics

[fa icon="comment"] 0 Comments

How to create reports using dynamic array formulas in Planning Analytics TM1

 

In our previous blog (https://blog.octanesolutions.com.au/what-are-dynamic-array-formulas-and-why-you-should-use-them), we discussed about Dynamic Array formulas and highlighted the key reasons and advantages to start using DA formulas.

Read More [fa icon="long-arrow-right"]

Dynamic Array formulas in IBM PA TM1 - Supercharge your reporting in Excel

[fa icon='calendar'] September 11, 2020 / by Amin Mohammed posted in TM1 Training, How to, PAX, PAX and PAW, IBM Planing Analytics

[fa icon="comment"] 0 Comments

 

Read More [fa icon="long-arrow-right"]

Octane Celebrates 4th Anniversary

[fa icon='calendar'] August 18, 2020 / by Amendra Pratap posted in IBM Planing Analytics

[fa icon="comment"] 0 Comments

2020 has been an interesting year for us !

 

Read More [fa icon="long-arrow-right"]

Session Timeout for TM1Web, PAW and PAX

[fa icon='calendar'] August 6, 2020 / by Rajan Bajracharya posted in TM1 Training, TM1 Support, PAX and PAW, IBM Planing Analytics

[fa icon="comment"] 0 Comments

Read More [fa icon="long-arrow-right"]

TM1 Undocumented Function - Renaming the Element Name

[fa icon='calendar'] August 4, 2020 / by Alpheus Dominic posted in PlanningAnalytics, TM1, TM1 Training, TM1 How To

[fa icon="comment"] 0 Comments

Renaming the element name – SwapAliasWithPrincipalName 

In Realtime Scenarios, sometimes we get the requirement to correct/update the Principal element name(s) in a Dimension. This would relatively be easy if the dimension is being used in one cube. In case where the dimension is used in multiple cubes, updating element name(s) without affecting the data of all the cubes, is a bit challenging. Either we export data of the cube and change the element name(s), then import the data and validate cube before and after the element change. Or deploy the Bedrock process, which requires the reboot of Instance.

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates

Recent Posts