Cognos Insight Per-built Theme

IBM Cognos Insight have multiple Per-built Themes for apply to your report / dashboard just two clicks ...on your report select style ..and then  Apply workspace theme.
I think this new features make differentiate from Oracle BI (OBIEE).

Cognos Insight Theme collection

Cognos Classic Theme

Cognos Focus Theme

Luminance Theme

Cognos Moondusk Theme

Cognos Vivid Theme

Start with IBM Cognos Insight

First step with IBM Cognos Insight.
For installation just normal application install on client machine.
Next open the Cognos Insight Program

First sight with Cognos Insight, look good , in the middle show file type that you can drag to see what's powerful of Cognos Insight.

IBM Cognos Insight first page

Sample data, just basic

Drag the excel file to Cognos Insight

The result , with in 2 seconds!!

You can change graph type in 1 second!

Connect String when install OBIEE

Format of Connect String when install OBIEE.
In help show the format like

• host1:port1:instance1
• host2:port2:instance2@servicename

But from my experience use pigserver.domain:1521:ORCL > is okay                                 

Please try servername:1521:ORCL

Create Domain error when configure OBIEE 11G

          I' found the problem when I installed OBIEE 11G , when install finish the process go to configuration but the first step of configuration the process will create the Domain , message show the error can't create domain.
          I tried to search in OTN discussion and found 2-3 issues.

• Java , if your Server is 64 bit , your java must be 64 bit
• Path and Class path please verify it
• Authorize of user that install the software

I tried 5-6 times but not work , and finally I found the cause of this problem > because my Server set regional doesn't is ENG ENG ENG!!!
My server set Thai regional . After I found I change all regional to ENG (US) and deinstall OBIEE and restart Server and new install and configuration > everything fine, smooth ,okay

I think this issue maybe occur with others ,if you use other language as native and your server configure with that language.

Thanks god 12 hours for install and Configure.

Oracle Hyperion Planning Certification Questions - Sample

Oracle Hyperion Planning Certification Questions - Sample

This question , the Certification guide told me 'E' is correct.
But from my opinion , I think should be 'D' ?

Should be 'D' ?

SQL Server marked as "suspect" #How to solve

If your SQL Server marked as "suspect" #How to solve it ?

First you must make sure your data file and log file still OK.
Then you use this command , run in ISQLW

update sysdatabases
set status = status & ~256
where name = 'XXXdatabase'

And then if your SQL response this message > Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.

You need to run this command

sp_configure 'allow updates',1
go
reconfigure with override





or



exec sp_configure 'allow updates',1
go
reconfigure with override

Cache Manager in OBIEE Cer question

Cache Manager question in OBIEE Certificate Testing

Question is
Which three statements are true about cache manager?
A. It can be used to view the contents of cache entries. > Yes can do it in Cache Manager
B. It is active in online and offline mode. > Online mode only!!
C. It can be used to purge entries by user. > Yes can do it in Cache Manager
D. It can be used to purge entries by physical table. > Yes can do it in Cache Manager
E. Can be used to specify maximum cache size. > Can't
F. Can be used to specify location of cache files.  > Can't 

Cache Manager Question

Cache Manager Detail

OBIEE certification questions

OBIEE certification questions

Which two of the following could be the disadvantages of implementing query caching?
A. Improved performance > caching help to improve performance >> advantage
B. Potential for cached results being stale > Yes this is disadvantage
C. Disk space for the cache > Yes this is disadvantage
D. Increased network traffic > caching help increase network traffic >> advantage
E. Reduction in BI server processing overhead > caching help BI server process

B and C is correct answer

IBM Cognos 10 Bug? with mod function

IBM Cognos 10 Bug? with mod function

          For mod function , syntax look like this mod (20,3) >> the result should be 2. But if you got some error please try to use ; instead of ,

          I loss my time 2 days for solve this issue. Amazing.

mod (10,2) >> error

Change to mod (10;2) >> No errors !!!

Use Oracle OBIEE report via IPAD / IPHONE

How to use IPad / IPhone see Oracle OBIEE report


          1st step you need to download Oracle BI apps from apps store.Basic installation same as normal Apple program.

Oracle BI Apps

          2nd step open the program and select Add Server

Add Server Page

          3rd Set all parameter

• Name : Use meaning name 
• Host : Ip Address (OBIEE Server)
• Port : 7001
• SSL :  OFF
• SSO : OFF
• Username : User of OBIEE
• Password : Password of OBIEE
• Save password : ON
• Device Locale : ON
• Analytics Path : Default
• Publish Path : Default

Oracle OBIEE Certificate Guide

This question about Calculation (How to..) but all choices look like not a relate. -_-

Please see the Question (from guide and from real Test is the same)

Ask for Calculation

Analyze OBIEE Certificate Exam Guide

Analyze OBIEE Certificate Exam Guide!


          I bought OBIEE (1Z0-526) Oracle Business Intelligence Foundation 10.1.3 Essentials Certificate Exam Guide from (Top) Web Site. And I tried to test Exam . The examination match with the Exam Guide. Choice is same. But the results for my Exam is failed!!!.
I tried to find out and I found 40-50% of Exam (Answer) guide is wrong ...oh.


I tried 2 times until I passed, for last exam I got 80%.

Exam Results

Some question that I found , we should think before select.
1. The Question quite not clear you can see 2 pics and judge by yourself.

Answer is D

This slide from Oracle OBIEE class

OBIEE Services start failed error JPS-06514

OBIEE (Weblogic) Services start failed error JPS-06514

Cause of problem: OBIEE 11g Weblogic server didn’t allow any user to startup the services without the right privileges. Most of the case the issue found while you use ‘User1′ installed the OBIEE Server but use ‘User2′ to the start/stop of weblogic server .

Error will shown like this

Solution , You need to add access privilege to file "cwallet.SSO" that in folder OracleBI\user_projects\domains\bifoundation_domain\config\fmwconfig\bootstrap

You can right click at that file and set privilege to that file allow any user that you want to use to start services.

cwallet.SSO