Hello People ,


Here is a document on simple reporting in dashboard 4 for beginners ,who are very much new to Dashboard Reporting Tool version 4.1

Here our source is BW System working on HANA database , we will be using the BICS(Business Intelligence Connectivity Services ) connection to consume the BEx Query created in BW on HANA  into our Dashboard Reporting Tool


Following are the steps :


Go to Start --> All Programs -->SAP Business Intelligence --> SAP Business Objects Dashboards 4 --> SAP Business Objects Dashboards


After Clicking  on  SAP Business Objects Dashboards then click on  blank model


    Dashboard's main screen will get open


   Click on file --> New


   Go to Query Browser --> Add Query


    Click on Add Query.


    Once you click on add query fill login credentials and then click ok.


You will find two options universe and BEx. As our source is BEx Queries from  BW on HANA  we will select  BEx and click on Next.


  Now select your username and click next.


You will find BW7.4 connection under connections and then click next

NOTE : This connection is already created , if not please contact the respective administrative team


   Now select the respective BEx query on which the reporting needs to be performed.


   Check the "Refresh Before Components Are Loaded "and click ok


   Go to Query Browser --> Select a particular dimension or measure and connect it with the spreadsheet ,by clicking on red arrow beside

   "Insert in Spreadsheet " and then Select the Range


    Now color the selected cell (it is not mandatory step , just for our reference so that we don't get confused ).


    Go to Components --> Select  Charts or Selectors as per requirement

   We have selected a simple Spreadsheet Table


    Select spreadsheet table chart


    Once you select spreadsheet chart drag and drop it.


Select that spreadsheet chart and click on preview button , you can view a very basic report



For End to End Scenario of Web Intelligence Reporting please find a link below :

End to End Scenario of SAP -BW on HANA-Web Intelligence Reporting

Subject: Data Visualization using SAP BusinessObjects BI On Demand

Purpose: Data Representation

Target Users: Executives/Managers/Business Analysts who want to represent their data with graphics/charts/visualization without any IT help.

Data Source: Excel Sheet

Go to https://bi.ondemand.com/session/new

Enter Your User ID and Password.


Go to Add New --> Add Template


Enter Your Visualization Name and Description. Then click Next.

Here I am going to show Customer Analysis.


When It is asking for User Agreement, please select I Agree.


Here I am going to design a dashboard based on excel sheet you can find this excel sheet at


Now select as shown in snapshot


After Uploading Excel Sheet, you can have your data as shown below


Now Select Column Chart from Components.


  1. Now go to Data- -> By Range and Select Your Data Range from Sheet--> Ok


After that you will be having as below chart.


Now Perform below steps


  1. Go to Appearance in Property--> Layout--> Unselect Chart Background
  2. Go to Appearance in Property --> Axes --> Horizontal Gridlines --> Unselect Show Minor Gridlines
  3. Go to Appearance in Property --> Text --> Select Mouse Over Values -> Select Data Labels --> Select Series1
  4. You can change Text Format and Size from Format Selected Text.
  5. You can also change theme for your visualization by selecting Themes as shown below.


Select Open Preview



You can have your visualization in new tab.


Greetings !!!!!!


You have successfully created a data visualization/dashboard by your own.


Best Regards.

Training on Selectors:

In this blog, data visualization was covered now this training is more on visualization. In this we are using selectors for data selection in dashboard.

For this we will use an updated excel sheet available at here.


Log in to BI On Demand & Import New Excel Sheet as described in steps earlier in this training.

After importing a new excel sheet, you must be having following status at your end.


In previous session we have done visualization on Customer Analysis, we will do same but for selected State and City only. So here selection comes into picture.

We will use Selectors



Now Select two Combo Box from selectors and assign title as shown below.




Now set properties for "State" combo box as shown below.





Set properties for "City" combo box as shown below.





Now Select a Column Chart and set its properties as shown below.




Run your visualization and you can have following









Here are basic steps to create visualization using SAP BusinessObjects Explorer in SAP BI OnDemand.


(1) Log on to SAP BusinessObjects BI OnDemand.


(2) Add Dataset.


(3) Here I am explaining visualization in Excel Data Sheet.



Select an Excel file and click on Add Dataset


(4) Select appropriate sheet.



(5) You will get your all columns available in your sheet,




(6) Now click on Explorer



(7) You will get your visualization




(8) Now you can change data for visualization


Select Explore More....




(9) Customers are already in Sort based on Sales Amount, now Select only top 10



(10) You will get visualization for Top 10 Customers (based on Sales Amount) only.....



(11) You can have more charts like this




Enjoy with SAP BusinessObjects BI OnDemand


Thanks & Regards,

-Harshil Joshi



     In this blog, I am going to discuss about different types of Business Objects and its usage among different roles in an organisation. I will also discuss what Business Object needs what type of data hierarchy. Further this blog will guide about how to extract Excel format data feed using SSIS tool for different Business Objects.




     As we know, SAP Business Objects (a.k.a. BO, BOBJ) is a French enterprise software company, specializing in business intelligence (BI). Since 2007, it has been a part of SAP AG. Its flagship product is BusinessObjects XI, with components that provide performance management, planning, reporting, query and analysis and enterprise information management.



The above snippet describes us that different user roles needs different types of tools to interpret the data in an organisation. For Example, Business Analysts require tool like BEx (Business Explorer) for their Analysis. BEx is a set of tools used for analyzing data in SAP. It has (1) BEx Query designer which is being used to design queries for user. (2) BEx Analyzer is a Microsoft Excel add-on tool for analysis. (3) BEx Web Application Designer (WAD) — A desktop application used for creating Web and analytic applications that render SAP NetWeaver BI information using tables, charts, and graphs. (4) BEx Report Designer — A desktop application used to create static or dynamic formatted reports. The reports can be viewed within a Web browser or generated as a PDF.


As we moved up towards higher management, relevant tools also require highly summarized information to display results. e.g. SAP BI-ONDemand explorer tool (http://www.biondemand.com/businessintelligence) require low level of summarized information. When we put data-set in this tool and click explore, it automatically analyse data based on different data fields given. We can then filter information based on our need. Data-set example is attached as an image of  Excel Sheet (BiOnDemandDataSet.jpg).


Discussing about XCelcius which is mainly used for Dashboard design, it requires high level of pivot information to present on a Graph or Dashboard. Pivot example is attached as an image of Excel Sheet (PivotDataSet.jpg).


Additional focus of this blog is to feed different Business Objects with their required information. Below SSIS image and SQL Query will give an idea who don't know how to extract data directly from SAP database without doing any intervention in SAP application, and this is also theme of Business Objects which works independently from SAP application.





Pivot Query:


select YEARS ,


          Coalesce([ACT],0) as [ACT],

          Coalesce([NSW],0) as [NSW],

          Coalesce([QLD],0) as [QLD],

          Coalesce([SA],0) as [SA],

          Coalesce([VIC],0) as [VIC],

          Coalesce([WA],0) as [WA]

from (Select states,[Years],counting from B_Pivot) as SRC

PIVOT (SUM([counting]) FOR [STATES] IN ([ACT],[NSW],[QLD],[SA],[VIC],[WA])) as pvt

order by YEARS


Email Delivery with Excel Sheet as an Attachment:


declare @startdate datetime,@EndDate datetime,@MySubject nvarchar(255);



SET @StartDate = DATEADD(mm, DATEDIFF(mm,0,getdate())-1, 0)

SET @EndDate = GETDATE()



Set @MySubject='Successfully Processed OEMSALES.xlsx File for Todays Date  ' + Convert(nvarchar,@EndDate,103);


exec msdb.dbo.sp_send_dbmail

     @recipients =N'Qaiser2001pk@Yahoo.com',

           @body = 'This file contains OEM SALES DATA From 2009 till today',

           @body_format ='HTML',

     @subject =@MySubject,



     @profile_name ='qaiser'





          From above discussion and developments, we can see that Business Objects (BOBJ) are independent of SAP application, and how much easy data extraction could be. Apart from using third party tool, BEx has also has query designer to build query and extract data. User just needs to know about schema/ERD (Entity Relationship Diagram) of the system. With these modern SAP tools, any user can extract data without having detail technical knowledge of  queries and programming. Bi-OnDemand is free online tool to do data exploration , however XCelcuis and Crystal Reports are not free. MS Excel also provides great visual intelligence and it is one of the cheapest tool in the market.

Also I would like to thank #BCO6181 to give me opportunity to write first ever blog for SAP. You can contact me on qaiser2001pk@yahoo.com or tweet @mqaiser2.




DISYS Announces Launch of SAP Business Intelligence Accelerator Tool, REV

DISYS releases a SAP BI Accelerator tool providing faster analysis and organization of data


Mclean, VA – April 23th – Digital Intelligence Systems, LLC (DISYS), a leading global IT solutions firm, has announced the launch of REV, their newly developed BI Accelerator tool made for SAP. REV joins DISYS’ recently released cloud enablement tool, Sirro, as the latest innovation from DISYS’ research and development arm, DISYS Labs.


REV efficiently analyzes the inventory of data to detect redundant and obsolete objects in the SAP Business Intelligence landscape. By leveraging this accelerator tool, a higher degree of quality and data integrity can be achieved when upgrading and consolidating objects. REV provides DISYS client’s faster access to relevant information, increasing the overall SAP BI system performance and enabling clients to make informed strategic decisions. DISYS BI consultants will utilize this accelerator tool to better harmonize data across multiple platforms, streamlining processes for the customer.


Ahmar Abbas, DISYS’ Vice President of Global Services, commented on REV “As we continue to innovate our services and expand DISYS Labs, REV provides our clients with a unique offering as it is a customized program built to maintain SAP BI applications that can automate processes required to manage the BI landscape. Our clients will benefit from optimized knowledge transition during BI support take over and identify new insight for future projects.”


Shanthi Mani, DISYS SAP Practice Manager stated, “REV allows the BI Application Support team to significantly save time on manual analysis. DISYS will be able to administer this tool for our SAP BI customers who have implemented SAP BI systems over the years and achieve the benefits of accelerated technical analysis.”


DISYS REV has been made available to DISYS clients and the public as of its release on April 23th. For more information, visit www.disys.com/about-us/rev/ or contact your DISYS Sales Representatives.


View the latest REV demo.


About Digital Intelligence Systems, LLC (DISYS)


DISYS is an ISO 9001:2008-certified IT solutions company serving Fortune 500 and other global-scale enterprises worldwide. DISYS delivers strategic value by understanding and responding to a client’s environment, problems, and challenges. Incorporated in 1994 as a certified Minority Business Enterprise, DISYS has nearly doubled in revenues over the past three years, and currently ranks as the second-fastest growing company in the staffing industry among companies with revenues exceeding $100 million. DISYS is headquartered in McLean, Virginia, with offices and delivery locations worldwide. To learn more about DISYS, visit www.disys.com.

For many companies mobile BI has so many options that they don't know where to start (and so they don't start).

In this blog I will show you how you can quickly (in a few hours) create a good looking mobile solution that can be used to show executives the sort of solutions that can be provided with mobile BI.


What you will need (The ingredients).


SAP BusinessObjects BI OnDemand   http://bi.ondemand.com/http://bi.ondemand.com/

SAP Interactive Analysis   https://www.sap.com/campaign/2010_curr_sap_crystal_interactive_analysis/

SAP BusinessObjects Mobile (from the iTunes store. Has both an iPad and iPhone version. Also available on Android)

Some relevant business data in an excel spreadsheet.


Note: This demo will be using the iTunes version of the software.


The steps.

Start by creating a BuisnessObjects BI OnDemand account (if you don't already have one).

Next download SAP Interactive Analysis (A 30 day free trial is available).

Install SAP BusinessObjects Mobile on your chosen device.


Select your data and load it into an excel spreadsheet. The data you choose should be relevant to your target audience, especially if you are trying to sell the concept to the decision makers in your organization. Keep the data reasonably simple as smart phones have only a small area for displaying your data and you don't want the screen to look busy.


Now save your spreadsheet as a CSV (Sap Interactive Analysis won't work with .xlsx files).


For this demo I have chosen monthly closing stock price values for two Australian mining companies. My spreadsheet therefore has 3 columns (Date/BHP share price/Rio Tinto share price). For your demo you might like to include Date/Budget/Actual




Run the Interactive analysis program. You will now see a blank canvas with 10 options in the menu bar.Select file, new and you will now see a "New Document" window. Select Other data source then press "Next>>".


From the "Select a data source" window you will need to use the "Browse" button to find and select your file.




From here just press next unless you specifically need to change something (such as the data separator or First row contains column names).


Next you will see a "Create Query" Window. Here you can change the field names, and define the fields as either Dimensions , Details or Measures. Make sure your field names reflect the data in each column. You will also want to keep the names as short as possible so that they fit on the mobile device. When you have finished press "RunQuery" at the top right of the window.


Create Query.PNG


You Should now see the main report design screen. Somewhere around the middle you will see your data presented in columns along with a report title. Because the final destination for this report is a mobile device I select the report title and delete it.


Note: The next step can be skipped if you don't want to create new variables. Simply browse down to the section "Creating a Graph".


For ease of use on the final report (in this example) I will show how to create new calculated columns. I am doing this to reduce the date to CCYY/MM instead of the full date stamp shown above.


Select the "Data" menu option at the top of the screen then select "Variables". You should now see the "Variable Editor" window.


I then use the following formulas to create my required CCYY/MM variable. The square brackets [ ] indicate a variable name.


YYYYMM=([YearNum]*100) + [MonthNum]



After you define each variable press OK. This will take you back to the main report editor. To add the second and third variables repeat the above steps.



Now select the first column of your report. Right click it and select remove column. You should now have a 2 column, 1row report.



To insert the new YYYY/MM date right click the first column and select "Insert column to the left.


You will now have an empty column. From the "Data" tab on the left drag the YYYYMM field and drop it on the blue column heading of your report. You will now have a screen similar to the one below.




To format the date simply right click the first date and select "Format Number". Select "Number" then use the entries from the screen below.




You will now have a nicely formated date and we can now create our graph.


Creating a Graph


Right click in the middle of your table and select "Turn To". You will now have a choice of various styles of Tables and graphs. For  this example I will select a simple line graph. Once you select your required style press "OK".




I now have what looks like a pretty ordinary chart. Ignore the temptation to resize or modify the report as I have found from experience that this can result in data that will not display on your mobile device! Once it reaches your device the data will be re rendered and will be much more presentable.


You now need to save your report. From the "File" menu select "Save as". Choose "Web Intelligence Document (.WID)". In this case I will call the report "SCNBlog.wid" and I will save it to my desktop. If you plan to create a lot of these reports then youu will probably want to collect them all in a specific folder.




You can now close the SAP Interactive Analysis program.



SAP Business Objects BI OnDemand


Start your web browser and head over to SAP BusinessObjects BI OnDemand   http://bi.ondemand.com/http://bi.ondemand.com/


Under your "My Stuff" folder select the "Reports Folder". If your a new user this will be empty.




Select the green "Add New" button at the top right and choose "Upload Report".


On the left choose "Web Intelligence Reports" then on the right you will need to brose to your .wid file and enter a name for your report. Now press the "Add Report" button.




All you need to do now is right click the report (in your "Reports" folder), and select "Enable Mobile Access". Your report is now ready to be viewed on your mobile device.




Access from your mobile device.


From your device start the SAP BI mobile app.

Select settings then in the "Choose a Connection" section select "BI OnDemand".

The Connection Details will already be loaded so move down to the "Authentication Details" section.

Enter your User Name for your BI OnDemand account and if desired you can also enter and save your password (handy if you don't want to time out during a presentation).

Now press done (Top right).


When asked "Do you want to connect to BI OnDemand Connection?" press "Yes"


Once you have logged in select the "Server button" on the top left of your screen. This will load up a list of all the reports available for you to select. Select your report and it will download to your device.


You now have your first mobile BI report ready to demonstrate and all within a couple of hours.


The report below was emailed from BI on demand using my iphone.




If you have any questions about this blog feel free to leave a comment and I will get back to you as soon as I can.


I would like to thank all of those who have encouraged me on this my first blog.


I would especially like to thank Tony de Thomasis for running a great class (BCO6181 - ERP Applications) at Vic Uni.

  如果你是品管部的主管,產品品質的好壞會是主管甚至是高層主管重視的支項。要如何及時掌握現下的品質狀況呢?我們可以對有關產品良率的報表設定排程,定期地看報表的數字。但是!假使工廠很大,每小時可產出上萬個零件,如果要能及時掌握零件品質,我們可以對報表設定每一小時做一次排程,這樣我們便能即時掌握現下零件的品質了!這時候是否有人會想那我每天接收那些報表,我光看報表就都不用做其他事啦?!        難道不能設一個門檻,當良率低於門檻的時候再收到通知嗎?當然是可以的!此篇文章會教大家如何去去建立一張當問題發生時會通知的報表。
















今天要做的是一張具警示效果的Crystal ReportCrystal Report提供很多種資料來源供我們使用。

















































































我們要做的是跟產品良率有關的報表,假設良率低於99%的時候,我希望可以收到mail通知,那該怎麼做呢?      其實Crystal Report有個警示的功能設定,我們只需要設定一個警示條件,當產品良率低於99%的時候就會觸發這個警示,如下圖。啟用這個警示知後,我們便可將報表發佈到CMS上。




















This great blog by Jelvie Grech reminded me that while I have tried BI OnDemand, I haven't shared my experiences with it.  I have talked about it in presentations at ASUG and BI 2012. Here is something you might consider trying:


Step 1: Set up an account in BI OnDemand at https://bi.ondemand.com/session/new

Alternatively, you can use your StreamWorks ID


Step 2: Upload a Crystal Report (that already has data saved with it)




Step 3: Add Report




Step 4: View report



So what is the benefit as you could otherwise view in this in a free Crystal viewer?  Well, you can also see the Crystal Report on the iPad or iPhone as well.


Step 5: Download BusinessObjects Explorer to iPad or iPhone




Step 6: View report on your iPad or iPhone


If you wanted someone else to view the report on their iPad or iPhone, then you could "Share" the report with them on BI On Demand.



In February, at BI2012, I was amazed that a couple of attendees did this during my session.  I am sure there are other ways of accomplishing the same thing, but this is one way I have used.



I work as a Business Analyst in the Safety and Workers Compensation department of a global logistics company. One of my duties is to prepare regular reports for different parts of the business to show how they are performing against their safety targets and provide data to help prevent against the re-occurrence of incidents. Every day at work, I would get the same request for information. People from all parts of the business would require graphs showing injury data, comparisons of motor vehicle accident data in the last few years and data specifically for a particular business unit. I would spend my time uploading data and creating queries in Microsoft Access for every request. Most of these queries use the same data that is updated every month. I’d have to create a graph for each query as a report in Microsoft Access or copy and paste the graphs in an Excel or PowerPoint document, then email it to those requesting them. Sometimes, the same people from different business units request the same information and I would do a routine email out to them every month.


There must be a better way.


I had heard of BI OnDemand very briefly in a lecture for the subject BCO6603 - ENTERPRISE RESOURCE PLANNING SYSTEMS at Victoria University, but never had a chance to explore it further. The lecturer, Paul Hawking (SAP Mentor), demonstrated just how easy it was to display graphs on his phone. He said all you need to do is upload your data and select the display options and the type of chart you want and it will create it for you. I thought, that would be a great idea to use for work but left it at that.



One of my subjects this semester is BCO6181 – ERP Applications, where the lecturer, Tony De Thomasis (SAP Mentor) told us about Cloud offerings. He asked what we were interested in and I told him that I worked with data and created reports and dashboards for the company I work for. He told me to bring a sample of data and he would show me how to upload them into BI OnDemand and create graphs. The next lesson, I brought a spreadsheet with data and had a look at what BI OnDemand could do with it. I was impressed. When we were asked to prepare a 6-minute hands-on presentation about something we learnt in the subject, I decided it would be a great opportunity to do a demonstration on how to create graphs, add them to the dashboard and update data in BI OnDemand. I found it so easy to use and can see the potential to have it as a tool at work. I can use

it to create graphs for specific business units and the sharing function will allow me to invite authorised members of those business units to either view or edit the dataset, visualisations and dashboard.



Here is a video I created based on the presentation I did in class:



It will be very exciting to develop a system where those who request graphs from me can log in to BI OnDemand and serve themselves to what they need. As seen in the video, it is very quick and easy to use. This is something that I have never seen at work before and I am very excited to be one of the first to test it. I hope those who I will be sharing it with, will embrace it as much as I have and find it as
useful. It was great to take something from the classroom and be able to apply it straight away in the workplace.


當您擁有非常豐富的客戶資訊,要如何將這些資訊分類轉化成商業助益呢?而分類方式眾多且繁雜,有沒有一種分類手法能最完善且有效率的幫助我們進行分類呢?  公司為了讓顧客持續回流,提供禮卷給消費總額達消費總體前20%的顧客,而前10%的顧客除了提供禮卷外,本公司將對這些顧客視為VIP潛客,並為這些顧客提供一個餐會以便能更進一步了解他們潛在的需求。  公司規模逐漸擴大,為了針對每種不同的客群提供不同的服務,公司將對這些顧客進行分類,然而分類細項達數百種,這又要怎麼分類呢?  老闆說,現在顧客類型以表定完成,除了行銷部門可對這些顧客做分析之外,業務部也該對這些顧客有一定的了解,那這樣的顧客分類應該要在哪裡就開始進行呢?  談到Custom Grouping,相信大家都有分類的經驗。但是!運用什麼樣的分類手法是最快又合適的呢?



  1. 行銷部為了維繫客勤,為了為不同等級的客戶採取合適的維繫方式,因此將對客戶進行分級,訂單總額大於50000000顧客為A級會員、小於10000000的顧客為C級會員,其餘為B級會員,請問用什麼樣的分類手法會較為適合呢?










  1. 某連鎖唱片行為了分析顧客聽音樂的類型,故為這些顧客進行分類,然而音樂的曲風有數十種,這時又該採用什麼樣的分類手法會比較合適呢?





























  1. 某間中小型企業,為對不同的客戶群體做不同的推廣,預計分出五大類的客群,而這五大分類是可讓公司某幾個特定部門的同仁拿來進行分析、統計或使用,在此種需求下哪種分類手法較為合適呢?
















Filter Blog

By author: By date:
By tag: