BusinessObjects Universe Designer – Sysdate Value Object
| Posted by watashii | Filed under BusinessObjects, Oracle, Software
Creating SYSDATE value objects in a Universe (via Oracle connection) can simply be done as shown above. I have simply created a single-value dimension object, which can be used anywhere within a query (result/condition/sort). Having sysdate values allows the flexibility to create dynamic time-based reports. For example you can schedule a weekly report to extract data from the past 7 days starting from the current time the report was run.
Note, when parsing the object against the database (Oracle), an error will appear. ORA-00903: Invalid table name.
You can just ignore this error and press ok.
Tags: BusinessObjects, oracle, sysdate, universe
Windows Vista – Change Sleep Button to Shutdown Button
| Posted by watashii | Filed under Software
Recently got my new computer system loaded with Windows Vista (Home Basic). The first annoyance I encountered was that the default power down on the Start Menu is the orange sleep mode button.
Having sleep mode allows quick resume of Windows without needing to reload Windows from scratch, as well as saving power – the benefits obvious.
But for the not-so occasional PC user, a shutdown button is more convenient. Here is how to swap it with red shutdown button.
- Goto [Start > Control Panel > Power Options]
- Click on the power plan in use, and select Advanced Power Settings
- Expand the + signs under Power Buttons and Lid, then Start Menu and Power Buttons
- Then in the dropdown box set it to the Shutdown setting
Tags: shutdown, sleep, vista, windows
Directly Modify & Edit A Webpage
| Posted by watashii | Filed under Software, Web
Want to modify a web page on your browser, or delete an image directly from the page? Here is a very cool shortcut that allows you to do this without using any other programs.
In fact, you can do this right here by loading this link.
Tip: Add the link as a bookmark, then whenever you would like to modify a page, just click on the bookmark. Easy!
Tags: bookmarklet, Web
Install and Run Ubuntu on VMWare Player
| Posted by watashii | Filed under Programming, Software
This was my first attempt installing a Linux operating system, and I decided to run it over VMWare on top of my Windows XP system. Its the perfect way for me to trial an operating system without changes to my system boot-up. This post shows how I got the Guest OS Ubuntu 8.10 (Desktop) running on the Host OS Windows XP (32-bit). And it was fairly easy it turned out.
Source files: [Ubuntu.zip]
Tags: install, ubuntu, vmdk, vmware, vmx
SSH Passwordless Authentication
| Posted by watashii | Filed under Software, Unix
This post shows how to use PuTTY (Windows) to login to a remote server (UNIX) over SSH without password.
Tags: authentication, passwordless, putty, ssh, unix
How to Change Default Homepage in Tomcat
| Posted by watashii | Filed under Software, Unix
When browsing to a Tomcat’s webserver, at the root URL over the default port 8080, it usually shows the default jsp homepage as pictured above.
http://localhost:8080
So how can I update / modify, or remove this page?
You might think changing the jsp page at [$CATALINA_HOME/webapps/ROOT/index.jsp] is all you need to do. This is where i found out its not the case! The page contents are compiled within the ROOT web application servlet. To make Tomcat reference the jsp page instead, we need to remove this servlet from being compiled.
Locate the ROOT web application’s config file at [$CATALINA_HOME/webapps/ROOT/WEB-INF/web.xml], and simply comment out the following code fragment:
<!-- Comment this section so I can change the default index.jsp homepage
<servlet>
<servlet-name>org.apache.jsp.index_jsp</servlet-name>
<servlet-class>org.apache.jsp.index_jsp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>org.apache.jsp.index_jsp</servlet-name>
<url-pattern>/index.jsp</url-pattern>
</servlet-mapping>
-->This will disable the index_jsp servlet. Now when you restart the Tomcat web application server, it should compile and load the default [$CATALINA_HOME/webapps/ROOT/index.jsp] page instead.
XP Themes Designed & Signed by Microsoft
| Posted by watashii | Filed under SoftwareWant a change for your current XP theme? Here are some nice themes for your Windows XP/2003 which are designed and signed by Microsoft. This means you can use these themes directly (Control Panel > Display Properties) without modifying any of your Windows system files.
For other non-signed user designed themes, you might like to check out the patching utility UxTheme Multipatcher.
Royale / Royale Noir Theme
Zune Theme
Embedded Theme
Tags: embedded, royale, themes, windows, zune
BusinessObjects – Delete Universes in CMC
| Posted by watashii | Filed under BusinessObjects, Software
When deleting Universes in the Administrator Central Management Console (CMC), under a BOXIR2 Unix installation, i got the following error:
Error. Unable to reconnect to the CMS XXX:6400. The session has been logged off or has expired.
The solution is to make sure the timezone environment variable is set under the user’s Unix profile (the user which installed BO).
vi /opt/bo/.profile
Add the following example timezone and source the profile.
TZ=Australia/NSW export TZ
source /opt/bo/.profile
Then restart the BO servers.
Tags: BusinessObjects, cmc, universe
BusinessObjects – Insert Webi Report Images
| Posted by watashii | Filed under BusinessObjects, Software
To insert external images on BO Webi reports, create a blank cell from the Templates tab, go to Properties tab, and under ‘Background image’ put the following custom image URL:
boimg://<filename>.jpg
Then on the BO server (Windows), place the image file under
C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Images
Or if you’re working under Unix system, its located at
/opt/bo/bobje/enterprise115/Images
Tags: BusinessObjects, webi
BusinessObjects – Internal Error when connecting Windows clients
| Posted by watashii | Filed under BusinessObjects, SoftwareWhen connecting with a Windows client using Designer or Import Wizard to a remote BOE XIR2 server, I got the following error:
Internal Error [repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure.)
This error message (generally repo_proxy) is a very generic error message and doesnt tell you much what is going on. Your problem may be different to mine. However this post shows the steps I used to troubleshoot the problem and make my windows client to connect properly.
Tags: BusinessObjects, designer, import wizard, repo_proxy
