While IBM Planning Analytics is an excellent database that allows you to easily slice and dice your data, there may be situations where you want to export data from the model. Maybe you want to share information with someone who uses different software or maybe you want to use your data in another tool? PAW version 99 introduced the ability to export a data set from the PAW interface.
To export data, right-click on a cube within a modeling workbench, select the option to Import/Export and then select the option to Export Data.
Once selected, you will be prompted to define the name of the .csv file that will be created. You then can define the data to be exported by using an existing view and/or by defining the dimension details. For each dimension, you can define a hierarchy to use, a subset to use, or an element to use.
You also have the ability to define filters for your numeric and string data (example: only show values greater than or equal to 100) and the ability to skip consolidated values, rule calculated values, and zero/blank values.
Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.
Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.
Read more IBM Planning Analytics Tips & Tricks:
A Resolution You Should Actually Keep: Upgrade Your IBM Planning Analytics Environment
Popular IBM Planning Analytics Videos of 2024
IBM Planning Analytics Tips & Tricks: PAW Export Dim Structure
