List of values in Business Objects A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. List of Values is a powerful feature that allows users to select from a pick list… Read More »
1. What are the differences between Personal, Shared and Secured connections? A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file. A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file… Read More »
Conditional Column Hiding in BO 4.0 BO 4.0 offers a flexible means of column hiding. This is actually a component hiding feature that works for table/chart etc. Let us take the example, where we have Store Name, Lines, Quantity Sold and Sales Revenue with a prompt for Product We want to display Sales Revenue only… Read More »
Normalized vs. Denormalized Normalization: Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy… Read More »
GreenPlum DBMS •highly scalable •fault-tolerant •high-performance •Based on Postgres •Shared-nothing architecture •Commodity hardware •Currently supported on Solaris, Linux HANA should be 100X faster than Greenplum or more for a typical query. This is due to the performance boost from avoiding disk I/O. Because memory is more expensive than disk, the cost of a HANA system… Read More »
Q: What is Synchronized Query in Business Objects? And how to handle it. #DATASYNC errors occur when you are working with multiple providers and you try to use unrelated objects from different queries. If you have Car Make and Sales Amount from one query and Year from another and try to build all three in… Read More »
SELECT date(current_Date) from dual; –10/28/10 (if current date is Oct 28, 2010) SELECT (current_timestamp) from dual; /* SELECT DATE_PART(‘MONTH’,current_date)from dual; SELECT current_time, DATE_PART(‘SECOND’,current_time)from dual; SELECT current_timestamp, DATE_PART(‘SECOND’,current_timestamp) from dual;*/ select add_months(current_date,-1) from dual; — DATE_TRUNC FUNCTION: SELECT add_months (date_trunc(‘month’, current_timestamp),-1) from dual; select add_months (date_trunc(‘month’, current_date),-1) from dual; –ADD_MONTHS FUNCTION: select add_months(current_date,-1) – date_part(‘day’, current_date)… Read More »
General Questions Q) Tell me about yourself, your employment history. Q) How many years of experience do you have in BusObj? Versions? Q) What was your role in the current project? Q) How many users were there? Q) On a scale of 1 – 10, rate yourself on BUSOBJ? Q) Designer Q) BusObj Q) Webi… Read More »
SetWindowsHookEx( ) this method allows a function to be added in the hook chain for particular events. For example: WH_CALLWNDPROC WH_KEYBOARD WH_CALLWNDPROCRET etc. So if we want to have a user defined function to be called for a certain windows event we can install a hook and then write our own procedure to handle the… Read More »