Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Usage of LAG function in Oracle BIP's child data set - Any Limitations?
SantoshKumarBhairi
Rank 6 - Analytics & AI Lead
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
Tagged:
0
Answers
-
Just to close it - looks like there is a limitation to use LAG function in child dataset.
0