Bookshelf Home | Contents | Index | PDF |
Siebel Life Sciences Guide > Importing Data into Life Sciences > Extracting Data for Mobile Users > Creating a Data Extraction RuleUse the following procedure to create a data extraction rule. This task is a step in Process of Analysis. To create a data extraction rule
You can create multiple rules for different types of extractions. For example, you could create one rule for Rx data and another rule for Outlet Level data. You can also extract data by multiple criteria (for example, sales force or position). The WHERE part of a SQL SELECT statement specifies the rows of the S_SYND_DATA table that should be exported. In most cases, this WHERE clause is WHERE T.POSITION_ID = [Position Id] When you specify the users to extract, it will match their position ID to the position ID on the syndicated data table and extract only the data that is visible to them. |
Siebel Life Sciences Guide | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |