Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Conditional validation using LOOP and variables. — Cloud Customer Connect
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

Conditional validation using LOOP and variables.

Received Response
9
Views
3
Comments
edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

Conditional validation using LOOP and variables.

Content

I know this might be strange, but I found a nice post by Mike Henderson. Essbase Users: Data copy inside IF

Based on that, I modified my script using this method to perform conditional validations instead of using IF.

Req: There are several requests with a request id (Tot_requests) that users submit, and management either approves or rejects where Approved will be copied from Working to Final.

Req_Approve is a Smartlist in the form that management selects by Request number.

There are few hundreds of requests, it works if the first request that it pulls either its Approved or Rejects and assumes the same for all requests and copies the data.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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