Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Not getting relevant data when calendar date Parameter applied on obiee publisher report using subje

Hi,
I have created bi publisher report using subject area..
i have added calender date parameter to publisher report .
in my report 10/07/2015 data only.
when i select that date(10/07/2015) from publisher report prompt, i am not getting data. it showing no data.
when i am selecting the 10/08/2015 date then i am getting data. showing results correctly..
why its happend.. please see the below screen shot
please help me..
is there need to change calender properties., configure files.?
i have tried with prompt on bi publisher report created using data model , i am getting correct data.
when i created parameter on bi publisher report using subject area , i am not getting relevant calender date data.
i f i select 10/08/2015, i am getting 10/07/2015 date data. next day data getting
i have tried so many times
please help me..
thank sin advance
Answers
-
Hi Kavya,
Were you able to resolve your issue.
I am facing similar issues in of my reports
0 -
Check your settings for timezones ... also post the WHERE clause of the query, I'll take a look at that too.
0 -
Hi Thomas,
SQL is exactly the same
Below are sql , for first i am getting values whereas for second no data
Saw the SQL from advanced tab in analysis
WHERE
(cast("Start Date"."Start Date" as date) = date '2006-08-01')
WHERE
(cast("Start Date"."Start Date"as date) = date '2009-05-15')
One thing which i observed now, i tried to create a prompt for the object and in that i didn't get an option for calendar?? any idea why?
0 -
Please post physical SQL that get's sent back to the database ... I'm wondering if you have data type issues ... why logically casting the start date?
0 -
Any resolution for this. we are also facing the issue. Cannot pass and match OBIEE Date format into BIP date format.
0 -
I've just updated the same question on https://community.oracle.com/customerconnect/discussion/comment/1236302#Comment_1236302
1