Journey with OBIEE

Monday, 30 November 2015

Compare last row results in OBIEE

›
Frequently User ask to compare last row results. If the dimension column is either Date,Week,Month,Qtr or Year then we can go with Time se...
Friday, 6 March 2015

Contert "Date" datatype Varchar to Date

›
CAST ( EVALUATE ( 'TO_CHAR(TO_DATE(%1,%2),%3)' , <<Date Column>> , 'MM/DD/YYYY' , 'DD/MON/YYYY...
Wednesday, 15 January 2014

OBIEE 11g - Single Apply Button

›
Steps to follow : 1.Don't hide " Apply " button from the dashboard.     If you hide " Apply " button, values pass...
7 comments:
Thursday, 5 December 2013

Usage Tracking in OBIEE 11g

›
Why Usage Tracking    It tracks the usage of the Reports and Dashboards. We will get to know the usage tracking while clicking on Manage ...
Tuesday, 26 November 2013

DENSE_RANK as a filter in OBIEE

›
  When we are using other than OBIEE function in a filter, we  will be getting an error saying that, "ora-30483 window functions are...
Tuesday, 12 November 2013

Import data from EXCEL to Oracle table using PL/SQL Developer

›
After long time I am writing this article. Here I am explain how we can import EXCEL data into Oracle table by using PL/SQL developer. H...
32 comments:
Monday, 1 August 2011

Is prompted Vs Presntation variable and Protect Filter

›
Both “ Is prompted ” and Presentation variable will do the sam...
2 comments:
›
Home
View web version

About Me

My photo
Kumara Swami Reddy
View my complete profile
Powered by Blogger.