Discoverer Explanation Part 2

Simple Folder : from Single Table

Complex Folder: Join two simple folders


Custom Folder : SQL query WHERE ORDER BY Having Group By


1)Connect to the Admin Edition
2)Create Business Area and Create Simple Folder
3)Connect to the Desktop Edition and Create new Workbook by select
  the Business Area whatever we have created.
4)Once we select the Business Area it will shows the folders which we have in the Business Area
  select folder and Columns => Select Next button and Finish Button
 
Note:- In the Business Area we have more than one Simple folder we can select only one
        simple folder columns not multiple folder

2)If we want to select  columns from Multiple folders then we will go for creation of
  Complex Folders.
 
VenodrID VendorName Cdate SiteID SiteCode Cdate City
=======  ========== ===== ====== ======== ===== ====

1)Create Two Simple Folders in Admin Edition
2)Select the Primary key from Simple Folder => Right click=>New join
   Select the Join Condition.
   Note: for Outer join select Options Button
         for multiple join conditions select Multi Item Button
3)System will create the join condition between the Simple folder we can find that end of the
  Simple folder.

4)Goto Desktop Edition and Create Workbook by select Business Area select the columns from
  multiple folders and design the Format.
 
Sort Options :
=============
1)Right Click on the Workbook column name => Item Properties  =>to change the Column Name
                                          => Group Sort       =>To make grouping
 => Sort Low  to High =>Assending order
 => Sort high to Low  =>Desending order
 => Foramt Data     => To format the Data
 => Format Heading  => Format the Heading
 => Format Exception =>To give the Format Conditions

Add Title to the Workbook:
=======================

1)Goto Tools Menu=> Options=> Table Tab=>Check the Title Check Box
  Double click on the Title Text enter the Title

2)Select the Button called Insert button  to Inser Date , Time, Parameter valued and so on

 
Custom Folder:
===============  SQL Query

1)Goto Admin Edition
2)Rigjht click Business Ares => New Custom Folder
                             => New Folder From Database to Create Simple Folder
3)Goto Desktop dition and select the Business Area
  we can find both Simple and Custom Folder
Note: Once we select column from Custom Folder Simple folders will be disabled we can not
      select the Colmn from simple folders.

4)Select the Column and Select Finish Button.