I am trying to use Oracle OAC pixel perfect (or BIP) email bursting functionality.
I created a datamodel/dataset using logical sql query with data source 'Oracle BI EE', and then a BIP report from it. It works fine, and I can even manually email that BIP report to other users. So email functionality works that way.
But then I added a bursting query in datamodel, where I also used logical sql query.
This logical sql query (for bursting) has all PARAMETER1, 2, 3, ... in column names with appropriate value. But when I trying to schedule the BIP report (where it uses the bursting query) it is failing.
According to log, the report ran fine, but it is failing in delivery, which is strange as email works fine (from BIP) without bursting.
If I create a BIP report by using physical database source in Datamodel/Dataset and also in bursting query then email bursting works fine for me.
My questions are:
(1). If the datamodel/dataset has logical sql query, then can we NOT use email bursting feature for that BIP report?
(2). If the datamodel/dataset has logical sql query, then should the bursting query still use a physical database source or can it use logical sql query?
I did not find any example in youtube or other places, where somone used logical sql query in BIP datamodel and then did exmail bursting. All examples are using physical data sources in BIP to create datamodel and email bursting.
Appreciate your help.
Thanks
Nasar