OBIEE11g Report Logo’s

OBIEE has some nice default report logo’s. Problem is you don’t always have access to the directory to browse them. Here is a Cheat Sheet:

Also available as PDF. download here

Till Next Time

OBIEE Get all users from RPD

I had to get all the users from a very large repository because they where implementing a new security model. Wrote a small script to make life easy:

'Read_Users.VBS
'John Minkjan
'http:// http://www.obiee101.blogspot.com/
'Get all the users from a repository
'1: Make an UDML export of the PRD using nqgenudml.exe
'2: Change the filename/location in this script
'3: Run the script from the command line cscript Read_Users.VBS > users.txt
Set objFSO = CreateObject("Scripting.FileSystemObject")

'point this to your UDML EXPORTSet
objFile = objFSO.OpenTextFile("E:\names.txt", ForReading)

Const ForReading = 1
Dim arrFileLines()
dim strRLinedim strTemp1dim strTemp2

i = 0

Do Until objFile.AtEndOfStream
strRline = objFile.ReadLine
if left(strRline,12) = "DECLARE USER" then
Redim Preserve arrFileLines(i)
arrFileLines(i) = strRline
i = i + 1
end if
Loop

objFile.Close
'Then you can iterate it like this
For Each strLine in arrFileLines
strTemp1 = MID(strLine ,15 , 50)
IF instr(strline,"}" ) >0 THEN
strTemp2 = MID(strLine , instr(strline,"{")+ 1, (instr(strline,"}") - (instr(strline,"{")+ 1))) ELSE strTemp2 = ""
END IF
WScript.Echo MID(strTemp1 ,1 , instr(strTemp1, """")-1) &";" & strtemp2
Next

Till Next Time

OBIEE creating large / huge PDF documents

When you try to create big PDF files in OBIEE after a certain size you will get an error like:

A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException at com.siebel.analytics.utils.InputStreamWithLimit.incTotalBytes(InputStreamWithLimit.java:58) at ...............

Basicly it means that the FOP processor is running out of workspace. The workspace is controlled from the instanceconfig.xml JavaHost part. Instead of enlarging the default value of 1024 kb you could also consider setting this to unlimited.

<JavaHost>
  <PDF>
     <InputStreamLimitInKB>0</InputStreamLimitInKB>
   </PDF>
</JavaHost>

Till next Time

OBIEE PDF controls (.fst files)

One of the heritages of previous Siebel releases are the pdfstyle.fst and the pivot.fst files. These files control partly the your PDF output looks and can be found in ...\s_{skin_name}\b_mozilla_4 .
Most of the time the settings are controlled by your .CSS files or the settings you make in your report. Some setting are still controlled by pdfstyle.fst and the pivot.fst (Like Title and Tapedeck).
It looks like Oracle is trying to transfer these controls to the .CSS files, they already did it with the pivot table and the regular. Still it’s handy to know where to “hack” if you have some strange PDF behavior.

Till Next Time