Not getting relevant data when calendar date Parameter applied on obiee publisher report using subje — Oracle Analytics

Oracle Analytics Publisher

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

Not getting relevant data when calendar date Parameter applied on obiee publisher report using subje

Received Response
233
Views
6
Comments
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD
edited Feb 21, 2024 8:29PM in Oracle Analytics Publisher

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

p1.png

p4.png

p3.png

Answers

  • 3244578
    3244578 Rank 3 - Community Apprentice

    Hi Kavya,

    Were you able to resolve your issue.

    I am facing similar issues in of my reports

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Check your settings for timezones ... also post the WHERE clause of the query, I'll take a look at that too.

  • 3244578
    3244578 Rank 3 - Community Apprentice

    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?

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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?

  • Sreevani Maddela
    Sreevani Maddela Rank 3 - Community Apprentice

    Any resolution for this. we are also facing the issue. Cannot pass and match OBIEE Date format into BIP date format.

  • gclampitt
    gclampitt Rank 6 - Analytics Lead

    I've just updated the same question on https://community.oracle.com/customerconnect/discussion/comment/1236302#Comment_1236302