OBIEE 11g not showing new dashboard in the drop down menu

When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu.

1. When you create a new dashboard under 'Shared Dashboard', it displays a warning, that "This dashboard will not appear in the "Dashboards" menu"

2. To make the dashboard appear in the menu, after you create new dashboard under 'Shared Folders', click  New > Dashboard again, and select newly created dashboard in step one as the folder, then give a name. 

3. Now after you create it second time, it will show up in the list.

Hope that helps

OBIEE11g Timestamp differencess

First Day of the Previous Year

TIMESTAMPADD( SQL_TSI_YEAR , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD removes a year from the returned date for the First Day of the Previous Year.

First Day of the Current Year

TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE) 

This calculation returns the first day of the year by deducting one less than the total number of days in the year.

First Day of the Next Year

TIMESTAMPADD( SQL_TSI_YEAR , 1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD adds a year to the date returned which will give the first day of the next year.

First Day of the Previous Month

TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the Current Month. The second TIMESTAMPADD then subtracts one month from the first day of the Current Month arriving to the First Day of the previous month.

First Day of the Current Month

TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) 

This expression gets the current day of the month and subtracts one less than the current day to arrive at the first day of the month.

First Day of the Next Month

TIMESTAMPADD(SQL_TSI_MONTH, 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

 From right to left the first TIMESTAMPADD returns the first day of the Current Month. The second TIMESTAMPADD then adds one month from the first day of the Current Month arriving to the First Day of the next month.

Last Day of the Previous Month

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the Current Month. The second TIMESTAMPADD subtracts a month to arrive at the first day of the previous month.

Last Day of Current Month

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD finds the first day of the current Month. The second TIMESTAMPADD adds one month to the date to arrive at the first day of the next month. The final TIMESTAMPADD subtracts one day from the returned date to arrive at the last day of the Current Month.

Last Day of the Next Month

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 2, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD finds the first day of the current Month. The second TIMESTAMPADD adds two months to the date to arrive at the first day of month after next. The final TIMESTAMPADD subtracts one day from the returned date to arrive at the last day of the Next Month.

Last Day of Previous Year

TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1,  CURRENT_DATE)) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD subtracts one day to arrive at December 31st of the previous year.

Last Day of Current Year

TIMESTAMPADD(SQL_TSI_YEAR, 1, TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD deducts one day to arrive at December 31 of the previous year. The third TIMESTAMPADD adds a single year to the date to arrive at December 31 of the Current Year.

Last Day of the Next Year

TIMESTAMPADD(SQL_TSI_YEAR, 2, TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD deducts one day to arrive at December 31 of the previous year. The third TIMESTAMPADD adds 2 years to the date to arrive at December 31 of the Next Year.

First Day of Current Quarter
TIMESTAMPADD( SQL_TSI_DAY , DAY_OF_QUARTER( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) 

This was included to show the calculations discussed above can be used with other functions. This is the same expression as the one that returns the first day of the current month except this one uses the DAY_OF_QUARTER property to return the first day of the current quarter.

Last Day of Current Quarter

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_QUARTER , 1, TIMESTAMPADD( SQL_TSI_DAY , DAY_OF_QUARTER( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) 

Demonstrated using Quarters. From right to left the first TIMESTAMPADD returns the first day of the Current Quarter. The second TIMESTAMPADD returns the first day of the next quarter. The final TIMESTAMPADD subtracts a single day from the date to arrive at the last day of the Current Quarter.

Number of days between First Day of Year and Last Day of Current Month

TIMESTAMPDIFF(SQL_TSI_DAY, CAST('2010/01/01 00:00:00' AS DATE), TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)))) 

For simplicity I hard coded the January 1, 2010 date and CAST it to a date. I could have used the First Day of the Current Year calculation but didn't want to over clutter the example. The second part of the TIMESTAMPDIFF uses Last Day of the Current Month calculation to force the TIMESTAMPDIFF to calculate the number of days between the first day of the year and the last day of the current month.

DAC11g Installation on Windows Server 2008R2.

DAC11g Installation.

1) Download DAC11g from OTN.
2) Extract the zip file.
3) Open the DAC extracted folder
4) Select DAC setup .exe file Run As Administrator.

5) Click on Next,

6) Specify the Informatica  Location, Click on Next.

7) Here specify the domain.infa file, Click on Next,

8) Here enter the DAC Home location, Click on Next.

9) Here select the create icons for all user check box, Click on Next.

10) Click on Install.

11) Click on Yes to All,

11) Wait untill complete the progress.

12) Your installation is completed successfully, Click on Done.

13) Go to start program files and select dac folder, Click on DAC Client,

Login Page.

14) Now Create dac user in the database and give role to dac user, See the below screenshot .

15) User created in the database.

16) Start DAC client-> Select Configure-> Select new connection.

Enter the connection name : OBIA
Select connection type : oracle(Tin)
Eneter service name : orcl.
Enter host name : kishore
Enter port no : 1521.



17) Select Authentication File -> First time select Create authentication file -> Click on OK.

18) Give the connection name -> click on OK.

19) Give Table owner name : dacuser ->Password : dac password -> Click on Generate radom Encryption Key

It will generate key 24 char key see the screen shot above.

 20) Click on Test connection -> You will see the srccessfully established message->Close -> Click on ok.

21) Click on start client, Select connection from the drop down and enter the credentials first time.

User name : Administrator.
Password : Administrator.

22) Click on Yes, Enter the table owner name and password (table owner means dac repository  username and password) as below screen shot.

23) Specify user name password for regulor login. In My case i am using credential
user name :  Administrator
Password :  obia

24) Close the dac window and login again -> Click on dac client -> In Login page  enter credential
->Click on Login.



25) Click on Setup Tab, DAC System Properties Enter dac repository name and informatica Parameter location. Click on save.

26) Go to toos->DAC server management->repository Configuration

27) Select web mode -> Click on Save (In the new dac11g there is two types security is available 1) web 2) standalone. for web u have to specify url, See the below screen shot).

This option is for when you integrate with weblogic that time you have to specify RUL or else you have to take standalone mode.

28) select standalone mode.

29) Enter the dac server host name : kishore and port no : 3141. Click on Save.

30)  To start server if it is web mode ->Go to toos->DAC Server Management->
start DAC Server. 
Stop DAC Server.
Stop DAC Server.

31)

32) DAC server setup. -> Tools -> DAC Server Management -> DAC Server Setup.

Click on Yes.

33) Select connection type as Oracle (Thin).
Server nam : Orcl
Host name : kishore
Post no : 1521.
select Populate from preconfigured client connection

34) Click on Test Connection. It will give connection pass message -> Close ->Click on Save.

35) Import Applications ->Tools -> DAC Repository Management ->Import
(To import application before u have copy those files from OBIEE_HOME\Oracle_BI1\bifoundation\biapps\dwrep\dac_client\server ->open exprot folder and copy all applications and move to DAC_HOME\dac\export.)
select the applications based on your ERP version in my case it EBS12.1.3

36)  Click on OK.

37) Now create a new container to modify the parameters in dac. After import completed u have to create the new container as a existing container, Because if you want to modify any thig in the dac it will not allow you , You have to created new container. See the below screen shot for more details.





38) Container Id : 11
     Container Name : EBS_R12.1.3
     Select Existing Container.

Click on OK.

Container created successfully.

39) Email Configuration.
       User Name : kishore
      Password : xxxxxx
      Email Server : smtp:gmail.com
      Port No : 465
      Email id : kishore1188@gmail.com

Click on Send Test Email. Done.

40) Enter Informatica details to integrate informatic server and dac server.

Integration service 
Service Name : info_is
Domain Name : Domain_kishore
User name : Administrator
Password : Administrator
Repository Name : info_rep

Click on Test connection, Click on Save. 

41) Enter informatica repository details to integrate informatica server and dac server.

Service Name : INFO_REP
Type : Informatic
Host Name: kishore
Port No : 6005
User Name : Administrator
Password : Administrator
Repository Name : INFO_REP.

Click on Test Connectionn -> Click on Save.

42) Generate the warehousing tables in the database. Using dac client.
Tools -> ETL Management -> Configure Source system

Select  : Generate create statement for data warehousing Tables

Click on Next.

43) Select Execute check box.
Select Physical Data Source type Datawarehouse
Click on start.

44) Data warehouse tables are created in the database., You will get success message at the end.

45) To check the Repository Stamp -> Help -> Login details

Here you can see all information related to dac repository.

46) In the new version of DAC11g You have keep generated 24 chra lenght key safetly, If you for get password , If you want to create new connection that time u have user this key again. or else you cont login to dac . it will give error key is not matched in the repository.

BI Apps 7.9.6.4 Installation in widows server 2008R2

Step 1:  Download the software from OTN, And unzip the software file.

Step 2:  Open the unzipped folder

• change compatibility ->Right click on setup file and select properties, 
• change the combustibility to service pack 2.
• click OK. 
• Run as Administrator, don't as run as a user (Because some security issues will come while starting service's)

Step 3: Double click on setup file.

Step 4 : Click on Next

Bi HOME : C:\OBIEE_HOME\Oracle_BI1
Instance Location : C:\OBIEE_HOME\instance\instance1
Domain Location :  C:\OBIEE_HOME\user_projects\domains\bifoundation_domain

Step 5 : Click on Next.

Here you have to specify the weblogic port no and weblogic user name and password

Step 6 : Click on Next.

Select applications  what you want to deploy (Or) leave as default.

Step 7 : Click on Next.

Step 8 : Click Next.

Wait until complete 100% Process, And it will stop bi server and start bi server automatically while installing

Step 9 : Once it will complete Click on Next.

Step 10 : Click on Finish.


After installation, Open the dwrep folder in the OBIEE_HOME\Oracle_BI1\biapps\Repository folder.

1) Copy Enterprise rpd and move to Bi Repository location (E:\OBIEE_HOME\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository).

2) Extract the catalog 
EnterpriseBusinessAnalytics from this location (E:\OBIEE_HOME\Oracle_BI1\biapps\catalog)

After extration move to the below location.

E:\OBIEE_HOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

Step 11 : Open the Enterprise Manager (http://hostname:7001/em)

Once you login, Deploye rpd and catalog. Now you have OBIA 7.9.6.4.