Save your Pivot Result to an IDEA Database

Brian Element

Forums

Hi,

 

The Pivot Table in IDEA always allowed the user to save the Pivot Result as an Excel file. 

 

Now the Pivot Table in IDEA also allows you to save the Pivot Result as an IDEA database. With the Pivot as an IDEA database, the user can apply further analytical tasks on the Pivot to glean further insights.

 

Kind Regards

 

Jairam

 

pomarquis Wed, 02/19/2020 - 13:01

Hi Brian,
i'm new to your website, and an absolute beginer in IDEA/IDEA Scripting.
So my question might have been answered in another post, sorry about that !
How do you extract the pivot table results as an IDEA database ?
Also is there a way to script the creation of a standard Pivot table for a repeating analysis script ?
Thanks in advance !

Brian Element Fri, 02/21/2020 - 07:02

Hello pomarquis and welcome to the site.

For you question, yes there is a way to get the ideascript code to create a pivot table.  You first would create your pivot table and then select the IDEAScripting button to get the script.

When you select the button it will open the IDEAScript editor with the pivot table code.

If you want to output your pivot table an IDEA database you would change the task.ExportToIDEA to true.  There is one limitation in that if you want to export your file to IDEA you can only have one row field, one column field and one data field.  If you select multiple fields for any of these items you can't send it to IDEA.  Also with this you can use variables for the field names so you can adapt this to other files.