Loading complex Excel spreadsheets into SAP NetWeaver BI

Summary

This article should help you get a quick start on using DataDefractor Solo to load complex spreadsheets into SAP NetWeaver 2004s BI (formerly known as SAP BW). It illustrates the process of converting a financial Excel spreadsheet into a complete structured data model and then loading it into an SAP BI InfoCube.

Applies to

Introduction

It might be useful in certain customer scenarios to extract data from complex business spreadsheet reports and load it into SAP BI InfoCubes for special data analysis.

This sample is based on a financial report provided by Freddie Mac, which is freely available at Freddie Mac’s website. It is also available in DataDefractor Solo samples’ folder. Therefore, it should be possible for every DataDefractor and SAP NetWeaver 2004s BI (SAP BI) customer to setup the same environment which was used here.

For the purposes of this example, SAP BI and DataDefractor Solo were deployed to a single Windows Server 2003 machine. The connection point between DataDefractor Solo and SAP BI is a set of flat files. Therefore, it is also possible to extract Excel data with DataDefractor on a Windows machine and then load it into SAP BI deployed to a UNIX machine.

Source spreadsheet

Freddie Mac PagedThe source spreadsheet is a financial report provided by Freddie Mac. It contains average U.S. national mortgage rates for 17 years, broken down by month.

The data model captured in the spreadsheet contains numeric mortgage rate facts recorded in the context of a time period. Let’s look at the contents and the layout of the spreadsheet.

Data Facts

Freddie Mac FactsThe facts are concentrated in several groups of numbers - one group per year. There are two columns of numbers for each month of each year - one column for the mortgage rates and one for the discount points that guarantee the rate.

Time Period

Freddie Mac TimeThe time period of the recorded facts consists of a year and a month of the year. The years of the facts are located in the header rows above each group of facts, while the months are located in the header column to the left of each group of years.

Product

Freddie Mac ProductAnd finally, the product that is being sold in the particular time period for the particular rate and discount points is located in the global header of the report - “CONVENTIONAL CONFORMING 15-YEAR FIXED-RATE MORTGAGE”.

Defining the data model

In this section we will use DataDefractor Solo Wizard to map out the data model captured in the mortgage rate report. We will draw the layout of the spreadsheet, define the location of the facts and define the dimensionality of the model. Once we’re done, we will use this mapping to convert the spreadsheet to a set of CSV files organized as a standard Kimball-style star schema ready to be loaded in SAP BI.

Step 1: Choosing a data source

Freddie Mac Page 1 - Data Source
The first step is to launch the DataDefractor Solo Wizard. You can start it by either double-clicking the DataDefractor Solo Wizard icon on your desktop or by navigating the following path on your “Start” menu:
Start\All Programs\Interactive Edge\DataDefractor Solo\DataDefractor Solo Wizard

The first page of the wizard asks you to specify the location of the data source.

Follow these steps:

  1. Select Excel radio button - this will launch an “Open File” dialog box.
  2. Navigate to the following Excel file:
    \Program Files\Interactive Edge\DataDefractor Solo\Samples\Freddie Mac\Freddie Mac.xls
    and select “Open”.
  3. Select Use all check box. This will instruct DataDefractor to use all the worksheets available in the workbook.
  4. Click Next to move to the next page of the wizard.

Step 2: Mapping out the data layout

Freddie Mac - Page 2 - Data Source LayoutIn this step we will define the data layout of the spreadsheet. We will start by isolating the header of the worksheet, then we will move on to slice the worksheet into vertical sub-pages and then slice those pages further into a collection of low-level horizontal sub-pages, which contain clear fact data surrounded but unbroken by context information.

Follow these steps

  1. Select Header/Footer radio button - this will isolate the header above the data area. A “Drill Down” reminder tool-tip balloon may pop-up - close it.
  2. Select the drill-down button Drill-Down Button to drill down into the data area. We can now slice this data area into vertical sub-pages.
  3. Select Vertical Sub-Pages. This will add a pattern row above the data area:
    Vertical Pattern
    We will use this pattern row to define a border-recognition pattern, which will split the data area into separate vertical pages.
  4. The spreadsheet is logically partitioned into several vertically stacked sub-pages. Each page contains a group of seven years. Looking at the report, we can deduct that every page begins at a row, which contains a year in column B. Click on the pattern entry below column B, type “^\d{4}” (without the quotes) and press Enter:
    Freddie Mac Layout - Vertical year pages
  5. Select the drill-down button Drill-Down Button to drill down again, this time into the vertical sub-pages. We will slice them further into horizontal sub-pages - one horizontal sub-page per year.
  6. Select Horizontal Sub-Pages. This will add a pattern column to the left of the data area. We will use this pattern column to define a border-recognition pattern, which will split the data area into separate horizontally positioned pages.
  7. We see that each horizontal page begins with a year in row 1. Click on the pattern entry to the left of row 1, type “^\d{4}” (without the quotes) and press Enter:
    Freddie Mac - Layout Horizontal Years
  8. Each horizontal sub-page begins with the year, but if we drill down, we will lose the month column. We need to carry it down into the new horizontal pages so that we can build a correct data model, which will consist of atomic low level virtual spreadsheets that contain facts and are surrounded by complete context information.
    Select property CarryoverColumns in the property grid below the layout radio buttons, type in 1 and press Enter:
    Freddie Mac Data Layout - Carry Over
  9. Select the drill-down button Drill-Down Button again, to drill down into the newly defined horizontal sub-pages:
    Freddie Mac - Horizontal Pages
  10. The new horizontal pages contain the lowest level of facts, the year and the month. We will move on to eliminating the extra blank columns to the right of the facts.
    We need to eliminate all the columns to the right of the last column, which has a non-empty cell in row 2:

    * Select Horizontal Sub-Pages
    * Set MatchSingleSubPage property to True
    * Set PatternDirection property to RightToLeft
    * In the pattern for row 2 type in the following regular expression (without the quotes): “.+
    (This regular expression matches any cell, which contains at least one symbol)
    Freddie Mac Layout - Horizontal Pages

  11. Drill down into the new pages.
  12. The only thing left to do is eliminate the footer of the virtual spreadsheets. This footer includes pre-calculated Annual Averages, which we don’t need in the data warehouse. Follow these steps to eliminate all the rows past the last row which contains the text “December” in column A:
    * Select Vertical Sub-Pages
    * Set MatchSingleSubPage property to True
    * Set PatternDirection property to BottomToTop
    * In the pattern for column A type in “December” (without the quotes)
    Freddie Mac - Eliminate Annual Averages

  13. We are done with defining the spreadsheet layout. Drill down into the new pages and review them by clicking on the tabs below the grid:
    Grid Tabs
    You should see a set of virtual spreadsheets with a uniform layout featuring twelve months in column A, mortgage rate facts in column B, discount points in column C and a year in cell B1:
    Freddie Mac Virtual Spreadsheet 1 Freddie Mac Virtual Spreadsheet 2

  14. We dissected the spreadsheet into smaller pieces and continued drilling into them until we reached to a repetitive uniform data layout, which contained a core of fact data surrounded by by context information. Now we are ready to move on and specify the precise location of that fact area and its context as it appears on all these virtual spreadsheets.
    Click Next to move to the next page of the wizard.

Step 3: Specifying the fact area

The fact area is indicated by picking the first row that contains facts and specifying the collection of columns that contain fact data.

Follow these steps:

  1. Click somewhere on row 4 in the grid to select it as the first row, which contains facts:
    Freddie Mac - First Fact Row
  2. Click Next to move to the next page of the wizard.
  3. On page Fact Source Columns, select columns B and C by clicking on the header of column C and dragging the mouse pointer over to the header of column B.
  4. Click button “Add Selected Columns” Add Selected Columns Button to add the selected column range to the list of column ranges, which contain facts.
  5. Select Flexible Range when prompted to select the type of column range to add to the list. This instructs DataDefractor to consider all the columns that appear to the right of column A as columns containing facts. This will accommodate spreadsheets which may contain more than two measures.
    Click OK to confirm the column range type:
    Freddie Mac Fact Column Range
  6. Click Next to move to the next page of the wizard.

Step 4: Defining the dimensional model

In this step we will define the dimensional model in terms of dimensions and attributes. We will also specify the location of each dimension and attribute as well as the location of measure names.

Follow these steps:

  1. Select item Measures in the axis tree on the left-hand side of the Axes Definition page.
  2. Select row 2 in the grid by clicking on the header of row 2.
  3. Click button “Add selected grid cells” Add Selected Columns Button to add this row as the source of measure names:
    Freddie Mac - Measures
  4. Select item New Dimension in the axis tree, click button Rename below the grid and type in Time; press Enter.
  5. While item Time is selected, select column A by clicking on its header.
  6. Click button Add Selected Columns Button to make the months represent the set of members for the time dimension.
  7. Click on cell B1 in the grid and click button Add Selected Columns Button to append the year to the names of the months. This will make the members of the time dimension unique across all virtual spreadsheets.
  8. Select Position when prompted to select the type of column reference:
    Freddie Mac - Time Dimension
  9. While dimension Time is selected, click button New Attribute below the grid and type Year; press Enter.
  10. While the new attribute Year is selected, click on cell B1 in the grid and click button Add Selected Columns Button to make the contents of cell B1 appear as the Year attribute of the members of the Time dimension; select Position when prompted for the type of column reference.
  11. Click button New Attribute again and type Month; press Enter.
  12. While attribute Month is selected, select column A by clicking on its header and click button Add Selected Columns Button to make the respective cell of column A appear as the Month attribute of each member of the Time dimension.
    Freddie Mac - Time attributes
  13. Click button New Dimension below the grid and type Product; press Enter.
  14. Click the drill-up button Drill Up Button five times until you zoom out to Level 1 of the spreadsheet.
  15. Click on cell B2 in the grid and click button Add Selected Columns Button to make the contents of cell B2 appear as the Product dimension; select Position when prompted for the type of column reference.
  16. The actual name of the product is a substring of the contents of cell B2. It is the string that appears before the word “SINCE“.
    To extract this substring select source Level 1: Cell:B2 in the list of Sources and click button Properties below that list.
  17. In the newly invoked Define Extraction dialog box, select extraction Custom regular expression and type in the following expression (without the quotes): “(.*)\sSINCE“:
    Freddie Mac - Product Name extraction
  18. Click OK to confirm the custom extraction rule:
    Freddie Mac - Product
  19. We’ve completed the dimensional model of the spreadsheet.
    Click Next to move to the next page of the wizard.

Step 4: Defining measure data types

Freddie Mac - Measure TypeIn this step we will define the data types of our measures. Both interest rate and discount point must be of type Float. Since this is the default type for all the measures detected by DataDefractor, we will simply verify the data type.

  1. Click on the name of each measure and make sure that property FactsType below the list of measures is set to Float.
  2. Click Next to move to the next page of the wizard.

Step 5: Setting output options and processing spreadsheet

Freddie Mac - Output OptionsThis is the last page of the wizard. Here we will specify the type of output we need and where to generate this output. We will also select some options which will make the output easier to load into SAP BI.

Follow these steps:

  1. Select radio button Star.
  2. Select field Files Prefix and type FreddieMacOutput.
  3. Select field Files Location and type output. This will create a new sub-folder output in the folder where the Excel file is located.
  4. Check check-box Include member names in fact table.
  5. Check check-box Include member names in fact table.
  6. The data mapping schema for converting Freddie Mac spreadsheets into a dimensional model is now complete. Click Save schema… to save the mapping schema for modifications or to be able to schedule batch processing of Freddie Mac Excel workbooks.
  7. Click Finish to process the current spreadsheet.

At this point, DataDefractor Solo processes the input spreadsheet applying the dimensional model and layout rules defined in the DataDefractor data mapping schema. When it is done processing, DataDefractor displays the results:
Freddie Mac - Results Dialog

Click on Open Destination Folder… to navigate to the folder where the output was generated.
The output is a classical Kimball-style star schema, which consists of three CSV files - one for the facts and one for each dimension:

  • FreddieMacOutput.Facts.csv - contains a normalized view of the facts extracted from the input spreadsheet. The measures are stored in separate columns. Each row in the file also contains dimension names and surrogate keys which can be used as foreign keys linked to the Time and Product dimension tables discussed below.
  • FreddieMacOutput.Time.csv - contains the keys and attributes of the Time dimension.
  • FreddieMacOutput.Product.csv - contains the keys and attributes of the Product dimension.

Loading the data into SAP BI

In this section we will load the output generated by DataDefractor Solo into SAP BI. We will use SAP Data Warehousing Workbench to build a data warehouse and to populate it with the Freddie Mac data.
Here is the list of procedures we will go through to accomplish this task:

  1. Build a dimensional model (InfoCube).
  2. Load the DataDefractor output into a Persistent Stage Area (PSA).
  3. Transfer/transform the data from PSA into the InfoCube.

Note: The following sections contain steps that create many SAP objects, some of which may need to be “activated” before they can be used. The steps to “activate” these objects have been omitted from this tutorial for brevity.

Step 1: Building the dimensional data model

Dimensional data modeling defines business entities such as cube, conformed dimension, attribute, measure etc. It provides the business user semantic meaning to diverse source data.
In SAP BI, the terms used to describe a dimensional model are:

  • InfoCube - a multidimensional data model, which contains facts that can be queried, pivoted and aggregated according to criteria defined by means of selecting dimension members on the various axes of the cube.
  • Characteristic - equivalent to a conformed dimension. Used to query one or more InfoCubes.
  • Navigation Attribute - equivalent to a conformed dimension’s attribute. Used to navigate and filter the members of a characteristic.
  • Key Figure - equivalent to a measure.

Freddie Mac SAP BW Data ModelIn this example, we will define the data model as one InfoCube FREDDIEMAC which consists of two characteristics - PRODUCT and TIME. The InfoCube also contains two key figures - POINTS and RATE. The TIME characteristic has two navigation attributes - YEAR and MONTH.

Follow these steps to build the model:

  1. Log into SAP BI using SAP GUI.
  2. Launch SAP Data Warehousing Workbench.
  3. Create a new InfoArea called IAFRED.
  4. In this area, create a new InfoCatalog called ICFRED.
  5. In this catalog create a new characteristic InfoObject and call it YEAR. Make its data type CHAR(8).
    Freddie Mac - YEAR Navigation Attribute
  6. Create another characteristic InfoObject in catalog ICFRED - name this characteristic MONTH. Make its data type CHAR(16).
  7. Create another characteristic InfoObject and name it TIME. Make its data type CHAR(16). Navigate to tab Attribute and add the YEAR and MONTH attributes to the list of attributes of the TIME InfoObject. Turn on the navigation option for both attributes:
    Freddie Mac Time Navigation Attributes
  8. Create a PRODUCT InfoObject characteristic in catalog ICFRED. Make its data type CHAR(60).
  9. Create a new InfoCatalog - ICKFFRED.
  10. In this catalog, create a new key figure InfoObject - RATE. Choose base aggregation SUM. Select exception aggregation AVERAGE on characteristic TIME. Make this key figure’s data type FLOAT:
    Freddie Mac SAP RATE Key Figure
  11. Create another key figure InfoObject in the same catalog - call it POINTS. Choose base aggregation SUM. Select data type FLOAT.
  12. Navigate to InfoProviders and create a new InfoCube FREDDIEMAC in InfoArea IAFRED. Follow these steps to build the InfoCube:
    * Define dimension PRODUCT and assign InfoObject PRODUCT to this dimension using Direct Input.
    * Define dimension TIME and assign InfoObject TIME to this dimension using Direct Input.
    * Using Direct Input, assign key figure InfoObject RATE to the list of InfoCube key figures.
    * Using Direct Input, assign key figure InfoObject POINTS to the list of InfoCube key figures.
    Freddie Mac - SAP InfoCube

Step 2: Loading Freddie Mac data into Persistent Staging Area

In this step we will load the input data into a Persistent Staging Area (PSA). PSA is an intermediate data storage area where data is collected before it is used to populate the dimensional data model.

Follow these steps:

  1. Navigate to DataSources.
  2. Create a new Application Component called ACFRED.
  3. Create a new DataSource FREDFACT of type Transaction Data and map it to file FreddieMacOutput.Facts.csv located in the folder used by DataDefractor Solo to generate the Freddie Mac star schema.
    Use the following data type mapping for the fields in this file:
    * TIMEID - INT2
    * TIME - CHAR(14)
    * PRODUCTID - INT2
    * PRODUCT - CHAR(45)
    * RATE - CHAR(10)
    * POINTS - CHAR(5)
  4. Freddie Mac - SAP Fact Data Source

  5. Create InfoPackage FREDFACTPKG under DataSource FREDFACT.
    Freddie Mac - SAP InfoPackage
  6. Navigate to tab Schedule and the execute the package to load the data into PSA.
  7. Create a new DataSource FREDTIME of type Master Data Attributes and map it to file FreddieMacOutput.Time.csv located in the Freddie Mac star schema folder.
    Use the following data type mapping for the fields in this file:
    * MEMBERID - INT2
    * NAME - CHAR(14)
    * YEAR - CHAR(5)
    * MONTH - CHAR(9)
  8. Create InfoPackage FREDTIMEPKG under DataSource FREDTIME.
  9. Navigate to tab Schedule and the execute the package to load the data into PSA.
  10. Create a new DataSource FREDPROD of type Master Data Attributes and map it to file FreddieMacOutput.Product.csv located in the Freddie Mac star schema folder.
    Use the following data type mapping for the fields in this file:
    * MEMBERID - INT2
    * NAME - CHAR(45)
  11. Create InfoPackage FREDPRODPKG under DataSource FREDPROD.
  12. Navigate to tab Schedule and the execute the package to load the data into PSA.

Step 3: Populating the dimensional data model

In this step we will populate the FREDDIEMAC InfoCube fact and master data with the data stored in PSA. To do this, we will define some transformations to transform, transfer and clean the data as it flows from PSA to the data targets.

Follow these steps:

  1. Under DataSource FREDFACT create a new InfoCube transformation targeting InfoCube FREDDIEMAC.
  2. Map the data source fields to the InfoObjects in the InfoCube by dragging lines from the data source to the InfoCube, following this mapping:
    * TIME to TIME
    * PRODUCT to PRODUCT
    * RATE to RATE
    * PTS to POINTS
    Replace the Rule Type of the TIME transformation with the following formula (without the quotes): “TOUPPER(TIME)“.
    Freddie Mac SAP Fact Transformation
  3. Under DataSource FREDFACT create a new Data Transfer Process.
  4. Navigate to tab Execute and click Execute to populate the key figures of the InfoCube:
    Freddie Mac - SAP Fact Transfer
  5. Under DataSource FREDTIME create a new InfoObject transformation targeting InfoObject TIME.
  6. Map the data source fields to the attributes in the InfoObject by dragging lines from the data source to the InfoObject, following this mapping:
    * MEMBERNAME to TIME
    Rule Type: Formula “TOUPPER(MEMBERNAME)
    * YEAR to YEAR
    Rule Type: Formula “TOUPPER(YEAR)
    * MONTH to MONTH
    Rule Type: Formula “TOUPPER(MONTH)
  7. Under DataSource FREDTIME create a new Data Transfer Process.
  8. Navigate to tab Execute and click Execute to populate the TIME master data.
  9. Under DataSource FREDPROD create a new InfoObject transformation targeting InfoObject PRODUCT.
  10. Map the data source fields to the attributes in the InfoObject by dragging lines from the data source to the InfoObject, following this mapping:
    * MEMBERNAME to PRODUCT
    Rule Type: Formula “TOUPPER(MEMBERNAME)
  11. Under DataSource FREDPROD create a new Data Transfer Process.
  12. Navigate to tab Execute and click Execute to populate the PRODUCT master data.

Step 4: Verifying the dimensional data model

Now that we’ve populated the InfoCube with facts and master data extracted from the Freddie Mac financial report, it is time to verify the results.

Follow these steps to verify the InfoCube contents:

  1. Navigate to InfoProviders, right-click on InfoCube FREDDIEMAC and select Display Data.
  2. Uncheck check-box Do not use any conversion.
  3. Choose Field selection for output and select the following fields:
    * PRODUCT
    * TIME
    * MONTH [TIME]
    * YEAR [TIME]
    * POINTS
    * RATE
  4. Click Execute twice.
    You should see the following query result:
    Freddie Mac - SAP InfoCube Result

The InfoCube is ready and populated with data, which can be analyzed using various front-end applications including NetWeaver Enterprise Portal, BEx Analyzer, BEx Web Analyzer, etc. Additionally with the help of DataDefractor Solo Batch Command, the extraction and transformation of future Freddie Mac reports can be automated and processing can be scheduled periodically. Furthermore, the loading of DataDefractor output into SAP can be automated with the help of SAP BI Process Chain.

58 Responses to “Loading complex Excel spreadsheets into SAP NetWeaver BI”

  1. abhay kale Says:

    When I try to create the DTP, it brings up a screen with the target area grayed out. It does expect an input and keeps me in error loop. So, I am able to take it up to PSA but no further.

    What am I doing wrong?

  2. Data Modeler Says:

    A very detailed and thorough description of a complex process. Loved the annotated screen shots. Well done.

    I hope to give this a try soon.

  3. Miyoko Ioannidis Says:

    That is a superb short article on SAP ERP. I liked the way you have expained the ideas in this article. Thanks a lot for such a nice writeup. Have you seen more content for all the SAP Modules. I am interested in mastering SAP more and would love to thank you for your time and efforts.

  4. karthik Says:

    Need a flat file source to work with business terms in it

  5. sites Says:

    I happen to be writing to let you understand of the useful encounter my cousin’s daughter developed viewing the blog. She noticed plenty of things, not to mention what it is like to have an excellent giving heart to let many people clearly fully understand a variety of complicated topics. You undoubtedly exceeded my desires. Thanks for providing the invaluable, trusted, edifying and in addition unique tips on your topic to Janet.

  6. Nilda Says:

    Undeniably believe that which you said. Your favorite
    justification seemed to be on the internet the simplest thing to be aware of.

    I say to you, I certainly get irked while people think about worries that they just do
    not know about. You managed to hit the nail upon the top and defined out the whole thing without having side-effects , people can take a signal.
    Will probably be back to get more. Thanks

    Here is my webpage: Nilda

  7. how to get on top of google Says:

    coolsite.thumbs up for posting.

  8. hostgator coupon Says:

    If you are operating a small business and are currently in the market for a web hosting service then there
    are a number of things that you need to take into consideration.

    Internet Marketing Training: Social Media Internet Marketing Training - Social media internet business marketing uses
    social networks (such as Facebook, Twitter, My - Space, etc), online communities,
    blogs, wikis or any other online collaborative media to promote your website, products
    and services. The affiliate coupon codes can easily be found on affiliate internet sites.

  9. midsummer.tv Says:

    To accomplish this balancing act for the body, chaste tree berry increases the production of certain hormones which reducing the production of others.
    Pile on the Praise When was the last time you really
    patted yourself on the back for a job well done. So do you best and look for a central location
    where to stay without spending a fortune.

  10. Aretha Says:

    Reducing the amount of fat in the diet is therefore the most effective way to
    reduce calorie intake. Warriors would often subsist on
    chia alone while on campaigns or conquests.
    Another current trend that may or may not be easily recognized as an
    ‘oldie but goodie’ is the new superfood, properly known as
    salvia hispanica.

  11. Tasha Says:

    00 for the fondant covered frosting, chocolate ganache icing,
    and marzipan frosting and $. Let it cool down for about 30 minutes
    before taking it out of the pan or adding frosting.
    Whenever the mixture becomes too dry and heavy, add a little milk to lighten it.

  12. Tina Says:

    Would you like to save money by not hiring a wedding planner, but you feel overwhelmed
    by the thought of trying to organize, track and complete all the details
    and tasks by yourself. This suggests banks will be in a position to borrow cash from
    the central authority at low rates and subsequently, they are going
    to be able to offer low interest private loans. This way, a slice can be removed from the freezer, defrosted,
    and eaten whenever the urge for birthday cake hits.

  13. Retha Says:

    a Bruce Lee workout includes stretching, bending, running, dipping, kicking, jumping, traditional muscle building exercises, weight lifting, rope skipping, medicine ball handling, etc.

    In fact, I always suggest to those overweight vegetarians to keep to a max of 4 pounds a week so you won’t suffer loose skin post weight loss. Many people don’t
    have the time to weight themselves every day, but checking the scale on a regular
    basis can definitely help when you’re working to lose weight and keep it off.

  14. Luanna Salotti Says:

    Everything is vastly unbolt with a earn explanation of the issues. It was really informative. Your website is vastly beneficial. Show gratitude you for sharing!

  15. google.com Says:

    My Last word on this = My Google Affiliate X (gaffiliatex)
    Review now comes to and end, but I just want to tell you that.
    The development team hopes to implement more complex search parameters
    so users can use full phrases and questions versus the typical keywords to search.
    If panoramic views are available, a red circle with “360″ will appear on the map.

  16. Raiya Shop Says:

    Diagnosed quite early, Prefetching data is?Its site a, your friends Search.Wisdom Fools only, up for grabs.The US as Raiya Shop, is easily confirmed credit reports Identity.Ever returning to, website is your.,

  17. seo tips wordpress Says:

    Hmm it seems like your blog ate my first comment (it was
    super long) so I guess I’ll just sum it up what I
    wrote and say, I’m thoroughly enjoying your blog. I too am an aspiring blog
    blogger but I’m still new to the whole thing.
    Do you have any recommendations for rookie blog writers?
    I’d genuinely appreciate it.

  18. DIY Acne cure Says:

    Peritoneal mesothelioma - Malignant peritoneal mesothelioma
    - this is a very rare form of cancer which strikes the peritoneum (the cell walls surrounding the abdominal
    cavity. Firstly it combats and gets rid of the bacteria on yiur skin that attacks your blackheads and whiteheads and transforms them into big red pimples.

    It also helps in tightening the pores and curbs the infection
    in the skin thaat may be causing acne.

  19. linking google plus and facebook Says:

    I believe everything composed made a bunch of sense.

    However, what about this? suppose you were to create a killer
    title? I ain’t saying your information isn’t good., however suppose you added
    something to maybe get people’s attention? I mean Defract This!!!
    Blog Archive Loading complex Excel spreadsheets into SAP NetWeaver BI is
    a little plain. You could peek at Yahoo’s front page and note how they create post headlines to get people to
    click. You might add a video or a related pic or two to get readers
    excited about everything’ve written. Just my opinion, it
    might make your posts a little livelier.

  20. best skate shoes Says:

    Undeniably believe that which you said. Your favorite justification appeared to be on the internet the simplest thing to
    be aware of. I say to you, I certainly get irked while people think about worries that they just
    don’t know about. You managed to hit the nail upon the
    top and also defined out the whole thing without
    having side effect , people can take a signal.
    Will likely be back to get more. Thanks

    my web page :: best skate shoes

  21. http://hvoicemag.com/ Says:

    We’re a gaggle of volunteers and starting a new scheme in our community.
    Your website provided us with useful information to work on.

    You have performed a formidable process andd ourr entire neighborhood woll
    likely be grateful to you.

  22. click to view Says:

    I blog often and I genuinely thank you for your content.
    This great article has truly peaked my interest. I’m going to bookmark your site and
    keep checking for new details about once a week.
    I subscribed to your RSS feed too.

  23. African mango Says:

    You really make it appear really easy together with your presentation however I to find this matter to be actually one thing which I believe I would by no means understand.
    It seems too complicated and very broad for me. I’m having a look forward for your next submit,
    I will try to get the grasp of it!

  24. masticating juicer reviews Says:

    For the reason that the admin of this website is working, no question very rapidly
    it will be well-known, due to its feature contents.

    My blog - masticating juicer reviews

  25. Garcinia Cambogia Extract Says:

    These are truly fantastic ideas in concerning
    blogging. You have touched some pleasant factors
    here. Any way keep up wrinting.

  26. Christie Says:

    Hello everybody, here every one is sharing these kinds
    of familiarity, thus it’s good to read this weblog, and
    I used to pay a visit this web site every day.

    Feel free to visit my web site :: how to get rid of acne scars
    overnight honey; Christie,

  27. software para digitalização de documentos Says:

    It incorporates the characteristic of evacuating
    additional spaces, heading and trailing spaces in Excel.
    However, the scanning software can reduce this cost
    and the savings can be used in some other important department to make the business flourishing.

    To grab Nokia dual sim mobile phones like
    nokia c1 mobile you can log on to numerous of online mobile
    stores.

  28. electronic document management Says:

    Determine what is the most common and offer the greatest advantages of digital.
    In taking close up shots, you can make your subject sharp (not
    blurred) and your background blurred. Security-wise, most methods use encrypted shield to guard data file from unauthorised access.

  29. bring your ex back with text sms Says:

    I was recommended this blog by my cousin. I am not
    sure whether this post is written by him as nobody
    else know such detailed about my difficulty. You are wonderful!
    Thanks!

    my blog post; bring your ex back with text sms

  30. weight loss diet Says:

    I was wondering if you ever thought of changing the
    page layout of your website? Its very well written;
    I love what youve got to say. But maybe you could a little more in the way of
    content so people could connect with it better. Youve got an awful lot of text for only having 1 or
    2 pictures. Maybe you could space it out better?

    my webpage: weight loss diet

  31. Dante Says:

    What i do not realize is in truth how you’re not actually a
    lot more neatly-liked than you might be now.

    You’re so intelligent. You realize therefore considerably in relation to this matter, made me in my
    opinion believe it from so many numerous angles. Its like men and women are not involved except it’s one thing to do
    with Lady gaga! Your own stuffs nice. At all times care for
    it up!

    Here is my site - house sitter los angeles wanted; Dante,

  32. computer repairs glasgow Says:

    With this application, both tins would draw the heat away from
    the underside with the case itself which will then heat
    up the water, evaporating it and then condense in the tin and fall
    back into the tray below. There are a couple of reasons your laptop won’t connect with the internet.
    The new internet enabled television sets use in the
    air transmission as well as broadband link to
    give more substitute for viewers.

  33. Arvind Pandit Says:

    However if you’re an international traveler or even a
    businessman you could choose Sky Harbor as a consequence of commercial need for Phoenix.
    Get an under-clothes wallet, as well as a watertight plastic bag which is slightly larger than your
    passport - a zip locking freezer bag works, using a
    piece of rigid (but thin plastic) that will
    be the same size - place your atm card, plastic card, rigid
    plastic and passport inside water tight bag, and place
    all this inside your under-clothes wallet.
    Good travel guides will need to have a pleasant layout with sorted typeface.

  34. round rock Used auto group Says:

    Try to present the list of the features which might be present in your
    device. In the season 2011, almost 60 million cars were produced across the world, and several of those will quickly be in the used-car market.
    The perception is that for sale by owner is always a
    money saver.

  35. Vernetta Alexader Says:

    Oh, Can you write more?

  36. watch premium tv channels on pc live Says:

    I like the valuable information you supply for your
    articles. I’ll bookmark your blog and test once more here frequently.
    I’m rather certain I’ll be told plenty of new stuff right here!

    Best of luck for the next!

    Feel free to visit my page watch premium tv channels on pc live

  37. garcinia plus consumer reviews Says:

    When I originally commented I seem to have clicked the
    -Notify me when new comments are added- checkbox and now whenever a
    comment is added I recieve four emails with the exact same comment.

    There has to be a way you are able to remove me from that service?
    Kudos!

    my weblog garcinia plus consumer reviews

  38. Gilda Says:

    Simply desire to say your article is as astonishing.
    The clarity in your post is just nice and i could assume you’re an expert
    on this subject. Well with your permission allow me to grab
    your feed to keep updated with forthcoming post.
    Thanks a million and please carry on the gratifying work.

    Here is my blog - garcinia cambogia hindi name (Gilda)

  39. Clinical Research Says:

    I think that what you wrote was very logical.

    However, what about this? what if you typed a catchier post title?
    I am not suggesting your information is not good., however suppose you added a post title to possibly get
    people’s attention? I mean Defract This!!! Blog Archive Loading
    complex Excel spreadsheets into SAP NetWeaver BI is kinda vanilla.
    You could look at Yahoo’s home page and watch how they create
    post headlines to grab viewers to open the links.
    You might add a video or a related pic or two to get people interested about what you’ve got to say.
    In my opinion, it might bring your website a little livelier.

    my blog … Clinical Research

  40. hostgatorcoupon.today Says:

    I’m not that much of a internet reader to be honest but your sites really nice, keep it up!
    I’ll go ahead and bookmark your site to come back
    later on. Cheers

  41. Lane Says:

    I’m really enjoying the design and layout of your site.
    It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire
    out a developer to create your theme? Fantastic work!

  42. slim spray reviews Says:

    We’re a gaggle of volunteers and opening a new scheme
    in our community. Your site offered us with helpful information to
    work on. You have performed an impressive activity and our whole community will likely be thankful to you.

    Feel free to visit my web page; slim spray reviews

  43. Our Masters Camps Videos Says:

    If some one wishes to be updated with most up-to-date technologies afterward
    he must be visit this web page and be up to date daily.

    my webpage … Our Masters Camps Videos

  44. holistic drug rehab center Says:

    Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I acquire actually enjoyed account your blog posts.
    Anyway I’ll be subscribing to your feeds and even I
    achievement you access consistently quickly.

    Here is my webpage holistic drug rehab center

  45. Our Masters camps Says:

    Hi there! I know this is kinda off topic however I’d figured I’d ask.

    Would you be interested in exchanging links or maybe guest authoring a blog article or vice-versa?

    My website discusses a lot of the same subjects as yours and I think
    we could greatly benefit from each other.

    If you might be interested feel free to shoot me an email.
    I look forward to hearing from you! Terrific blog by the
    way!

    Feel free to surf to my weblog: Our Masters camps

  46. drug rehab centers Louisiana Says:

    Attractive section of content. I just stumbled upon your website
    and in accession capital to assert that I acquire in fact enjoyed
    account your blog posts. Anyway I’ll be subscribing to your augment
    and even I achievement you access consistently rapidly.

    My blog post - drug rehab centers Louisiana

  47. substance abuse rehabilitation program Says:

    Hi there! This is my 1st comment here so I just wanted
    to give a quick shout out and say I truly enjoy reading your
    articles. Can you recommend any other blogs/websites/forums that deal with the same subjects?
    Thanks a lot!

    Here is my weblog: substance abuse rehabilitation program

  48. Our Masters Camp Says:

    Wonderful goods from you, man. I have understand your stuff previous to and you’re just too great.
    I really like what you’ve acquired here, certainly like what you’re saying and the way in which you say it.
    You make it entertaining and you still take care of to keep it wise.
    I can not wait to read much more from you. This is
    really a great site.

    My web blog; Our Masters Camp

  49. t=29&feature=share Says:

    Thanks for a marvelous posting! I certainly enjoyed reading it, you
    can be a great author.I will make certain to bookmark your
    blog and will eventually come back very soon. I want to encourage yourself to continue your
    great job, have a nice holiday weekend!

    Check out my blog post :: t=29&feature=share

  50. token Top eleven Says:

    The onus is also the penalty area. Witnesses and a harness
    to keep in mind for you. He is a matter of the most viewed and potentially most
    important position in MANU over the ball! And European soccer’s governing body,
    mind and reality. Laisa was also assessed by urine color and a crowd favorite at Madrid that Stéfano would show the colours of
    South Africa. Paulo Bento even tried to head the ball top eleven hack with his
    extraordinary footwork and technique.

    my web blog; token Top eleven

  51. controler sa colère Says:

    Thanks , I’ve recently been searching for information approximately this subject for a
    while and yours is the greatest I have found out so far.
    But, what concerning the bottom line? Are you sure about the
    supply?

    Here is my web site: controler sa colère

  52. liproxenol max reviews Says:

    What’s up, yeah this paragraph is really good and I have learned
    lot of things from it about blogging. thanks.

    my weblog: liproxenol max reviews

  53. Bradly Says:

    Thank you for the auspicious writeup. It in reality
    was a enjoyment account it. Glance complicated to more brought agreeable
    from you! However, how can we be in contact?

    my web-site - casting couch winnie (Bradly)

  54. free huge tits picture Says:

    When someone writes an piece of writing he/she keeps the
    thought of a user in his/her brain that how a user can understand
    it. Therefore that’s why this article is perfect.
    Thanks!

    My blog post :: free huge tits picture

  55. quest nutrition quest protein bars this Says:

    It’s impressive that you are getting ideas from this article as
    well as from our argument made here.

  56. casino spål på nett Says:

    We stumbled over here coming from a different page
    and thought I should check things out. I like what I see so now i am following you.

    Look forward to looking over your web page again.

    My website: casino spål på nett

  57. max burn cambogia Says:

    Excellent, what a blog it is! This web site provides valuable
    facts to us, keep it up.

    Feel free to surf to my web blog max burn cambogia

  58. forever garcinia plus Says:

    forever garcinia plus…

    Defract This!!! » Blog Archive » Loading complex Excel spreadsheets into SAP NetWeaver BI…

Leave a Reply