Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE - Creating Agent from Analysis with "Is Prompted" fields - returning 0 rows.

Received Response
19
Views
1
Comments

Hi,

First time post here with hopefully a simple question.

I have created an analysis with various prompts; on the analysis there are also 3 fields that are set as “Is Prompted”.

I'm trying to create an Agent that runs the analysis, but every time it runs, it says there are 0 rows found. I tried a Condition to check if the result is greater than 0 and this comes back False.

Running the Analysis seperately outside the Agent is fine though. I'm assuming it's something to do with the “Is Prompted” fields, and how do I get around this? Should I be handling the Is Prompted fields somehow or just leaving them as they are?

If any more information is needed, please let me know

Many thanks!

Tagged:

Answers