Hi Subhakar, Please, review next doc https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-C2C5B43E-4BB9-4ED7-94DE-D262698DCF98.htm#BIMIG-GUID-C2C5B43E-4BB…

Can you try this 0+IFNULL(CASE WHEN ... THEN 0 ELSE 1 END ,0)

Hi, Perhaps, you need obiee data dictionary

Hi, Can you try this: Evaluate('TO_CHAR(%1 ,%2)' AS CHAR ,"Creation Date"."Creation DateTime",'DD-MON-YY hh:mi AM')

Hi, the guide should help you, Please read this: Creating and Developing Custom Styles, Skins, and Messages in Oracle BI EE 11g

I have the same issue, user can't set starting page

Hi Felipe, I have the same issue with both approaches. OBIEE cannot find my custom style. Also, I have issue with blafp style:

Use conditional formatting

\Oracle\Middleware\Oracle_Home\bi\bifoundation\jee\analytics.ear include alta, blafp and other styles. You may extract this file. Correct way to developing: http://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG918

Hi, Here is guide to developing your custom style for obiee: http://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG9185 \Oracle\Middleware\Oracle_Home\bi\bifoundation\jee\bicustom-template.ear

Hi, Can you create a new user and try to login to BI.

Hi, You have done all steps correctly. The first step is correct ( Perhaps you should add quotes '@{pv_date}' ). The second step - You have added presentation variable to formula. Also, you can add default value to pv variable using this option or write youself (as you've did) for example: @{myFavoriteRegion}{'Central'}…

Creating and Developing Custom Styles, Skins, and Messages in Oracle BI EE 11g

Hi gchiham, you can use presentation variable for example @{pv_date}. You can create a dashboard with prompt and try to pass a value to the variable. * CASE * WHEN TIMESTAMPDIFF ( SQL_TSI_DAY , "Employee"."ABAY Start Date" , * CAST ( Evaluate ( 'TO_DATE(%1,%2)' AS CHAR , * CAST ( YEAR ( @{pv_date}) AS VARCHAR ( 4 ) ) * ||…

Hi, which version of OBIEE do you have?

* Oracle\Middleware\Oracle_Home\bi\bifoundation\jee\bicustom-template.ear * \bicustom-template\bicustom\res\s_Custom\master\oracle_logo.png Extract the bicustom.war file from the bicustom-template.ear file. Extract the files from the bicustom.war file.

Thanks

\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\msgdb\pages\

Hi, Please read this article. Maybe it helps you. Oracle Alta UI - A modern design system Perhaps, you have progressed at customization in OBIEE 12c. Can you describe how you do that? Thanks