Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

setRowFilterCriteria

edited Sep 23, 2024 8:31PM in Financial Consolidation and Close 2 comments

Summary:

Has anyone used the groovy dataExporter with .setRowFilterCriteria() specifying both single members and metadata conditions? I'm trying to create a data export (not to file, I'm planning to do some math and reimport) but I need to filter on a single member for most dimensions and then pull level0 of a parent in one dimension.

I'm getting this error from running the below code:

A method called by the script failed on line: 28, with error: The member 00$_run_closure1$_closure2@1d885aaf does not exist for the specified cube or you do not have access to it.

Or if I leave setIgnoreUnknownMembers as true it ignores the Movement filtering.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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