You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error to export data using PowerShell

in Enterprise Data Management 2 comments

Hi everyone!

I need to export data from test to production environment and i'm using PowerShell because it's a big storage data to migrate. As explained at docs im using the follow script and steps which is used in example: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cepma/sample_script_11_export_aso_cells.html#GUID-15AC2131-978B-40A4-BB62-55A2DA67498B.

However, im still having problems related to the amount, when the code is runing after processing file show a message "Error" in logs Windowns PowerShell.

At jobs i recieve the follow message: Unable to obtain dimension information and/or perform a data load: The number of cells generated by the MDX query has exceeded the threshold. Review the data export definition. Also review the use of member driven Smart Lists for ASO cubes, if defined.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!