BI Publisher (MOSC)

MOSC Banner

BI Publisher Report

edited Feb 19, 2014 12:00PM in BI Publisher (MOSC) 2 commentsAnswered

Hi Everyone,

Good Morning!!

I have a requirement from a user to show GL Balance data for MTD and YTD current and last year.

The user should input a value  as a parameter to the report and the report should get the data for the input date’s MTD and YTD Balance.

Example : if the user inputs 12-Feb-2013, the report should fetch the data as below

MTD_Current_Year

01-Feb-2013 till 12-Feb-2013

MTD_Previous_Year

01-Feb-2012 till 12-Feb-2012

YTD_Current_Year

01-Jan-2013 till 12-Feb-2013

YTD_Previous_Year

01-Jan-2012 till 12-Feb-2012

To achieve the above requirement, I have created a query with the required logic and trying to implement that in BI Publisher but im getting some errors in the Data Model.

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