If I select “Jan 2015” then rolling 6 month for
Current Month would be – Jul 2014 -Dec 2014 and
Previous Year – Jul 2013 – Dec 2013
If SAP HANA is a source then use below formula
“_SYS_BIC”.”./AN_XXXXX”.”DATETIMESTAMP” < add_months(current_timestamp,-1) Read more
If you use hyperlink wizard to convert a URL to a dynamic hyperlink in Business Objects WEBI report then it would point you to same url (or WEBI Document) with different parameter values but you get into trouble when you want different url’s or webi reports on the same column based on some value. (i.e clicking on each link should take you to different WEBI reports or OpenDoc URL’s)
You can achieve this by using Read more
Introduction: Query browser is a brand new addin in SAP Business Objects 4.0. Before dashboards 4.0 when you want to source the dashboards with corporate data, you would use QAAWS/live office (query as a web service). From 4.0 onwards SAP has given a provision to connect to the universes directly using query browser. That’s only one side of the enhancement. The other side being that you can connect to a BEx query directly from the query browser. This has replaced the need for using the SAP Netweaver BW connection.
Advantages of using Query Browser: Before looking at the limitations of this topic, let’s look at the advantages of using the Query browser. SAP is promoting the query browser big time. Let’s look at why Read more
How to pass BEx variable (Parameters) values to an SAP Xcelsius dashboard
Use Case: You have a parent dashboard, and a child dashboard. Now you want to pass parameters from parent to child.
Background:Traditionally dashboards(xcelsius) are able to embed opendoc url’s within them and invoke webi reports along with passing parameters. This works like charm with the url component invoking these links. But when it comes to invoking the dashboards, there are a few extra steps we need to include(in the parent) to achieve the same.
What you need to have in parent and child SAP dashboards:
- Parent dashboard: A URL link with all the syntax to pass the parameters to the child
- Child dashboard:Flash variables configured to receive the parameters from the parent dashboard and also refresh the queries in the child dashboard.
How you do it? Follow the below steps Read more
If you need alternatives to query browser in SAP Dashboards, Consider BIWS (SAP Business Intelligence web services)
Background: Your company has invested millions of dollars and purchased the BI 4.0 suite for reporting and dashboarding.
Problem: You are trying to build a dashboard in the traditional way and now you cannot map Bex variables to excel spreadsheet.
What does that mean to a dashboard design? SAP has restricted its customers from mapping the variables from BEx to excel spreadsheet. That means the only we can refresh a query is to use the “Query Prompt selector“. The query prompt selector itself works fine but its always a combo box for selection from user. If the user wants to click on the chart and refresh a query then its not possible. That is when you need to map the variables to the excel spreadsheet.
What can be done? Read more
SAP introduced new tool (SAP BusinessObjects Design Studio) for Dashboard development using SAP BW and HANA as backend. Through this tool SAP also introduces power of OO scripting (sap dashboard scripting) in Dashboards. Current version of SAP Dashboard (Xcelsius does not support any programming except excel based formulas and lookups. Design Studio scripting enable interactivity when user performs an action in the application.
SAP BIAL is a subset of ECMAScript. Read more
When you try to create 1st application in SAP Design Studio you also need Data Source Connection. If you don’t have default SAP BW and you are trying to find other connection (ex: SAP HANA) then first you’ll need to add ODBC connection for HANA.
Here are the steps:
1. Open Design Studio Read more
SAP HANA studio is the interface between HANA database and reporting layer. It is the area where we degin our muti dimentional models (ex: based on start schema – where we have fact table and dimention tables).
SAP HANA studio consists of several applications. It is also called as Perspectives (It means to see from different angle).
Currently we have four perspectives Read more
Old Name New Name
Dashboard Builder BI Workspaces
InfoView BI Launch Pad
Import Wizard Upgrade Management Tool
SAP BEx Analyzer SAP Business Objects Advanced Analysis
Voyager SAP Business Objects Advanced Analysis
Web Intelligence SAP Business Objects Web Intelligence
Xcelsius SAP Business Objects Dashboard Designer