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 »