Do you have a proper key for your week in time dimension? Are you using the week column from time dimension in report?

The first thing you should try is the basic oracle documentation. Also download a sampleapp VM and explore it yourself. It is easy to configure and try. There are tons of examples for OBIEE development. http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html Learn the architecture and…

Icons are changed in 12c for measures and non measures. is it not aggregating properly. Each criteria?

What is the aggregation rule in both criteria?

This cannot be configured based on measures apart from answers.

So How did you add it as the last column in pivot? Also Filter function is better than wierd case, But unfortunately Oracle BI will convert the filter function to case statement when executing in DB as database doesnt know what is filter function

I dont think it will add to the results .. I will show you an example. Here i kept debit - credit In OBIEE Pivot as far as i know we cannot add a column after the pivoted columns.

When it is placed in Rows area how aggregation matters ?

You can create a new column in criteria like below. SUM(case when ColumnDebit/Credit ='Debit' then Amount) - SUM(case when ColumnDebit/Credit ='Credit' then amount) and place it in the Rows Area of Pivot. the only thing is variance will come first.

If it is exporting from pivot the maximu number will vary , Even though you habve 30000 limit there you maynot be able to export may nbe 10k records. <Pivot> <DefaultRowsDisplayedInDelivery>9999999</DefaultRowsDisplayedInDelivery> <DefaultRowsDisplayedInDownload>9999999</DefaultRowsDisplayedInDownload>…

if it is in the format JAN-17 use below substring('@{PVT}',Locate(';','@{PVT}',-1)+1,6) or if you have JAN-2017 substring('@{PVT}',Locate(';','@{PVT}',-1)+1,8) For JAN only substring('@{PVT}',Locate(';','@{PVT}',-1)+1,3)

Try LocateN or Position Function and use it in substring.

Dear Saro, Why not find the last occurance of , and then take a substring from it?

Even if we apply the presentation variable in common filters it will work with multiple values. But when it is used inside a column formula it will not. Seems like he is searching for this. https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1418868_1.htm…

When it is assigned in column formula, it used to pass like below. case when MonthYear in('Jan-2014,Feb-2015,Mar-2016,Apr-2017') then ... end instead of case when MonthYear in('Jan-2014','Feb-2015','Mar-2016','Apr-2017') then ... end

Hello Saro This is will not work until the late editions of 11g. and it works fine from then. So which is your obiee version. OBIEE 11G: Error: "[nQSError: 27005] Unresolved column: saw_0 (HY000)" When Populating a Variable Prompt with a SQL Statement (Doc ID 1345964.1) Passing multiple values to a presentation variable…

Do not edit your current measure column. add a filter for "- Inventory"."Projected balance" convert it to sql and paste the below formula in it "- Inventory"."Projected balance"< case when '@{YourPresentation Variable}{All}' ='All' then 9999999999 else 0 end Variable prompt should be like below.

create a variable prompt and add two custom values All and Negative add a filter in report like below (Try to find the maximum value BI Supports and keep there (9999999999) YourMeasureColumn< case when '@{YourPresentation Variable}{All}' ='All' then 9999999999 else 0 end

There are many articles explaining the issues related to connection pool, also, if you search in OTN you will find n number of threads with solution. https://businessintelligence.technology/2014/09/07/the-connection-has-failed-error-when-trying-to-import-metadata-into-obiee/…

Hello Ramesh, Do you have the TNS file in the server? anyway check the connection by pasting your tns etnry in the TNS Name like below ( Complete entry like below) (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=yourdbIP) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=yourservice name) ) )