It's been a while since the last post.Today, I just want to talk about something we run into on our project related to defining 'date' using repository variable.Defining a dynamic variable that returns yesterday's date is pretty easy by just adding the following statement in the initialization block:select sysdate-1 from dualThe result shows that it also comes with hours and seconds after the date, like so:Now changing the statement to select trunc(sysdate...
Find trivia IT Project challenges here
I provide solutions
Various scenarios of designing RPD and data modeling
Find the easiest and most straightforward way of designing RPD and data models that are dynamic and robust
Countless examples of dashboard and report design cases
Making the dashboard truly interactive
The concept of Business Intelligence
The most important concept ever need to understand to implement any successful OBIEE projects
Making it easy for beginners and business users
The perfect place for beginners to learn and get educated with Oracle Business Intelligence
Wednesday, June 29, 2011
Subscribe to:
Posts (Atom)