BI Publisher (MOSC)

MOSC Banner

How can I edit .XDO and .XPT files to create variations of reports?

in BI Publisher (MOSC) 9 commentsAnswered

I need to run report jobs with variations of a data source WHERE clause (to output the results to different users).

I want to do this by creating multiple data sets (with the SQL query variations) in a single data model and multiple layouts using these source variations. The SQL queries are easy.

But I want to find a way to save the layout (as a new variant) and then point it at a different SQL query. It would be easy to save the layout as an alternate and then create a new table with the alternate SQL/data set. But there are many of these.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center