The purpose of the article is to address the relative information of modeling an ad copy through real-time data warehousing. In modern enterprises the day-to-day activities information is to be stored in data warehouse. We have taken the example of data warehouse concept from SAP Business One application as an element of Enterprise Resource Planning software, where it acts as an internal data source by providing the external environmental solutions. Through the ERP software, we have given special focus in planning the advertising strategy. At present the ad creators who are creating advertisement by using the trial & error method for collecting the product or service information with out getting updated information about the present situation. If we want to create an ad campaign, we have to make real & sensitive information in the advertising theme. So, we need to overcome these demerits with the real & updated information about the market place. By using this specific kind of database warehouse, we can provide an on-demand access to real-time information through one single system containing financial, customer relationship management, manufacturing, and management control capabilities.
[...] Total by Customer-Select to display a row for each combination of an item and customer (or items group and customer) in the report. Total by Sales Employee-Select to display a row for each combination of an item and sales employee who sold it. Posting Date From . To, Due Date From . To, Document Date From To-Enter the date range for the sales documents to be included in the report. Define a range for the posting date, due date or document date. [...]
[...] -Choose the required sales employee Stages-Choose the required sales stages to be included in the report Dates-To filter the report to a specific time .Enter any combination of the required start, closing and predicated date Industry-Choose the required industries from the list by Documents-Choose the required document types related to your opportunities . Amount-Choose and from the Amounts window that displays, choose the required range for the potential amount, weighted amount and gross total profit. Percentage Rate-Choose the percentage rate . [...]
[...] To collect the current information for preparing an ad copy by using data warehousing in a simplified way To analyze the information for develop the advertising strategy by using of data warehousing in the sense of data mining by using of SAP Business One To enhance the sales and to achieve the objectives of the organization both horizontal and vertically To give the suitable suggestion for betterment of creating an ad campaign. A new Dimension of preparing an Ad Copy - Enterprise Information Integration Solution for advertising: It means that an integration of an information about the business process problems and finding the repetitive solution to the particular problem. [...]
[...] To display the purchase for each item in an items group, double-click the row number of the respective items group. No Totals-Select to display one row for each item or items group (depending on the choice you have made in the field above). Total by Vendor-Select to display a row for each combination of item and vendor from whom you bought that item (or items group and vendor). Total by Sales Employee-Select to create a row for each combination of item and sales employee that bought the item. [...]
[...] Recommended-Choose to open the Recommended Solutions window and to view a list of solutions used in similar service calls. Add-Choose to open the Solutions Knowledge Base window and to create a new solution for the problem. Service Contract - Service Calls Tab. Call No.-Displays the number assigned to the service call. Click to open the Service Call window. Creation Date-Displays the date on which the service call was created. Subject-Displays the description of the problem reported in the service call. [...]
using our reader.