I have tried to applied not equal to 0 filter on the first report of the union measure column but results not changing.. Here in the above screenshot: 1. If I don't have any revenue(Book Value USD) for Cob Date then first table should not display as we don't have data(but it's showing comparison date data even we are not…

Hi Robert! But as per my requirement I don't want to replace cob date with comparison date if cob date is null, I have issue with first table which is having only cob date filter and it should display data for cob date only and if cob date is null then it shouldn't display my first table in the above screenshot...but this…

If I don't have data for cob date and have data for comparison date then the 2nd table showing correct results, but in first table also picking same data like 2nd table. Ideally it shouldn't happened.

Yup, Data means 'Book value USD' column in dollars, I already tried with ifnull function but no luck.

Sure! Union 1: Field company1 is 'Book Value USD' Filter: Cob Date='30-Nov-2018' Formula: "Measures"."Book Value USD" USING "Date"."COB Date" IN (@{pv1}{date '2018-11-30'}) Union 2: Field company is 'Book Value USD' Filter: Cob Date='30-Nov-2018' or Comparison Date='31-Oct-2018' Formula: ("Measures"."Book Value USD" USING…

Suppose if I have data for cob date and comparison date then it's working perfectly, issue is with when we don't have data for cob date and have data for comparison date then only arising this issue.

Hi Robet, Thanks for quick response, I have cob date field on the first union and I have cob date and comparison date fields on the second unions.

Hi Berg, Thanks for reply. Could you please explain the control file configuration process in detail..

Hi Berg, Thanks for response! I'm using OBIEE 12.2.1.2.0. I need same date format(eg. 30/Jun/2017 ) in the whole platform. I tried to change date tags as below in NQSConfig.ini, but the BI services are failed DATE_TIME_DISPLAY_FORMAT = "dd/mmm/yyyy hh:mi:ss"; DATE_DISPLAY_FORMAT = "dd/mmm/yyyy"; TIME_DISPLAY_FORMAT =…

Hi Robert, Thanks! Forget about electrical/mechanical/hydraulic...I have data like switch,plug,cord,fuse...etc. Here when I create the Pivot graph it splits the data. But I want to split the data with borders as shown in the below graph.

Hi Above analysis is from pivot view prospective in OBIEE(I have one date column in table and taken comparison date column in filter and created new calculated column(variance) in pivot view on date column like ($1-$2). I have to create same variance column(revenue difference between two date) in normal table.This is my…

Hi Robert, Try this, Make the changes to your table & Pivot table parameters in 12c instanceconfig file as per 11g instanceconfig file. Earlier I faced the same problem and it was resolved for me. Thanks, Madhav

I have installed OBIEE 12c and then did the migration by using migration tool.