Integrated Operational Planning supports MDX queries that retrieve a slice of cubular data. Using isadmin commands, you can export this same data to relational tables to be used elsewhere. You can also use these commands to archive information on a recurring basis before a new data refresh.
The following command takes a query name as an argument, creates a relational table, and populates the table with data returned by the query.
snapshot data using query queryname (append|replace)queryname refers to the named query in the system. You must create this query before running the command. append adds the data to the end of the table. replace drops all the rows and then adds the new rows to the table.