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