Displaying Images in OBIEE

1. Upload the images to following two folders

 
 

D:\ORAHome\j2ee\home\applications\analytics\analytics\res\s_oracle10\images (Oracle application server install)


 

D:\OracleBI\web\app\res\s_oracle10\images (OBIEE install)

 

 

2. After adding images to the folders you need to restart the presentation services

 

 
 

3. In answers, edit the title view and add the following

fmap:images/your_namename.gif

 
 

In dashboard you can use the same with image or link and fmap:impages/your_gif.gif

 


SQL Server Date Time formatting

Datatime manupulation in SQL server

 

 

SELECT
CONVERT(CHAR(10),LASTUPD_EW_DTTM,121)
FROM PS_D_DEPT

 

Result

2008-06-06


Data Stage Project File backup (updated)

:: @This batch file creates a backup of the project SSC_DEV4 and zips(rar) and then deletes the unrar file.

:: Precondition : 1)Terminal is mapped to Y drive.

:: 2)DataStage_Project_Backup is mapped to the mapped Y drive.

:: 3)winRaR installed and set on the PATH variable.

:: 4)Datastage server installed on the terminal.

:: Postcondtion : 1)RaR project date stamped file created.

:: Set the following as per the location of this batch file.username and password are for the datastage server.

set BackupDrive=Y

set BackupFolder=DataStage_Project_Backup

set DSProjectName=SSC_DEV4

set ZipPreFix=Z

set username=sriaddala

set password=Addala01

 

for /f “tokens=1-5 delims=/ ” %%d in (“%date%”) do set fdate= %%e-%%f-%%g

echo “%fdate%”

dscmdexport.exe /H=ssc-epmtst-app /U=”%username%” /P=”%password%” /O=0 “%DSProjectName%” “%BackupDrive%”:\\”%BackupFolder%”\\”%DSProjectName%”_”%fdate%”.dsx

 

rar a -rr10 -s “%BackupDrive%”:\\”%BackupFolder%”\”%ZipPreFix%””%DSProjectName%”_”%fdate%” “%BackupDrive%”:\\”%BackupFolder%”\\”%DSProjectName%”_”%fdate%”.dsx


Word Blogging with Pictures

I was trying to blog with MSWord after I noticed few days back MS added this feature just before they released Word. So I tried to setup my blog in Word with blogger but the problem is I cannot upload pictures to blogger from Word. It keeps throwing me the error that it cannot publish pictures to this blog and when use the more information button it takes me to the same one pager help that is available. On this one page help they talk about using photobucket, imgspot etc. Ok now I set up my account on the photobucket and change my picture options to photobucket link. Well, I knew this was not going to work because photobucket requires username and password to upload pictures but word does not accept any username and password. So now I try some free upload sites like imgspot. Well I would guess at least the free websites would work. Same error and same one pager info!! Again!! And finally I tried with wordpress. I had to setup my account at wordpress . You need to setup your free account for blogging here. After you login you will get some geeky number blog which you can change in the settings page like this

 

Now how do you setup your blog to upload pictures?. Well there is nothing to setup for pictures with wordpress. For wordpress it Word did it for me like this. Ofcourse you have setup your account like this

And in picture options select myblogprovider like this

 

And that is it. If you are reading this post with pictures in it ..then my first blog with pictures worked….