Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Usage of LAG function in Oracle BIP's child data set - Any Limitations? — 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

Usage of LAG function in Oracle BIP's child data set - Any Limitations?

Accepted answer
15
Views
1
Comments
edited Mar 14, 2019 1:46PM in General Transactional Reporting (OTBI) 1 comment

Summary

Usage of LAG function in Oracle BIP's child data set - Any Limitations?

Content

Hello,

I am trying to LAG function in a child dataset of Oracle BIP but it gives an 'ORA-01722: invalid number'. And if I execute the data-model on its own as Parent, it works fine.

Can anyone please help me with a wokaround? Or is there a limitation to use LAG function in child-datamodel of BIP?

thanks,

Santosh

Version

Release 13 18c

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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