» » Reporting on Analysis for Microsoft Excel

10

We have created the Analytic model to view the plantwise sales quantity.  Let see how to build the report using the view on Analysis for Microsoft Excel.

  • Goto Start menu > Program > Businessobjects > Analysis for Microsoft Excel.

3-22-2016 1-22-09 AM

  • Goto Analysis tab and Select data source.

3-22-2016 1-22-36 AM

  •   Skip the logon screen to use the Local ODBC connection to HANA

3-22-2016 1-24-57 AM

  • Select the HANA ODBC connection. Press next.      

3-22-2016 1-25-08 AM

  • Navigate to folder. Select the Analytic or Calculation views from the Package.

3-22-2016 1-27-09 AM

  • Report will be generated based on the view.

3-22-2016 2-18-44 AM

  • To Further build the report drag and drop the measures and dimensions in the columns and rows.


3-22-2016 2-23-29 AM

Posted by

Share to:

Post a Comment

  1. Chris AngleApril 5, 2019 at 11:40 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. IMFAugust 24, 2019 at 12:33 PM

    That is the excellent mindset, nonetheless is just not help to make every sence whatsoever preaching about that mather. Virtually any method many thanks in addition to i had endeavor to promote your own article in to delicius nevertheless it is apparently a dilemma using your information sites can you please recheck the idea. thanks once more. grammar checking

    ReplyDelete
  3. high technologies solutionsDecember 17, 2019 at 8:20 AM


    Nice post
    sap training institute in Noida
    sap training institute in Delhi

    ReplyDelete
  4. high technologies solutionsDecember 23, 2019 at 12:08 PM

    Interesting post post by you
    sap training institute in Noida
    sap training institute in Delhi

    ReplyDelete
  5. high technologies solutionsDecember 29, 2019 at 1:28 PM

    This post gives required information to visitor.
    SAP training institute in Noida
    SAP training institute in Delhi

    ReplyDelete
  6. markthomsonJuly 28, 2020 at 3:44 PM

    Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks this website

    ReplyDelete
  7. Jack AlexanderAugust 31, 2020 at 7:57 PM

    In an effort to find true reviews on websites like Discount Mugs and other shopping sites, Google Reviews was the one place to find a legitimate reflection of the company. Safer Reviews

    ReplyDelete
  8. NOAHDecember 31, 2020 at 10:17 AM

    I normally use Excel to control information and discover designs. At the point when I'm happy with the data I have accumulated and controlled, I as a rule can simply duplicate the data and glue it anyplace I need, for example,
    Excel Expert

    ReplyDelete
  9. CheatSykFebruary 3, 2021 at 2:12 PM

    This basic grievance with Microsoft Excel is heard on numerous occasions by engineers, bookkeepers, the executives consultants, investors and money experts who work with Excel spreadsheets consistently.spreadsheet consultant

    ReplyDelete

Subscribe to: Post Comments (Atom)
 
Top