Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to take first value as default value in design studio through scripting


I am Working As a BO Consultant,Present I am working On Xcelsius dashboards have created Top 10 Customers client need Same dashboard in Design Studio I have Implemented but I am Facing Small Issue while doing this. My Question is once i run the dashboard based on  from and to date customers will update and same time materials need to update based on from and to date and on first  customer at Initial(Here want to take Hero moto corp at first time )after that based on selection in customers automatically materials will change by using Set filter,But how to take first customer to effect for Material at first initial running,Could you please help on this.

From Date 02.2014 to Date as Blank

customers             net value                                   materials             net value

Hero Moto Corp     1000000

Tvs Motocorp          200000

Former Member

Hi Sathish,

Thanks for the screenshot.  Let me try to explain.  In your Xcelsius dashboard, you have the Top 10 customer table and the first row is always automatically in the selected state by default.  As a result, the filtering of the materials for the other connected charts is automatic.

However, in Design Studio, if you use a crosstab component to list your Top 10 customers, unlike the Xcelsius table, the first row is not in the selected state by default, so the onClick event is only triggered when a row is clicked.  As a result, on startup, the filter for the customer materials is not automatically triggered.  Therefore, as a workaround to this limitation, as I have described above, you need to create a separate query that returns ONLY THE TOP CUSTOMER.  This query should be assigned to a NEW DATA SOURCE in your Design Studio dashboard.  Then on startup, you need to apply the getMembers() method to this data source to retrieve the default top customer, which you then apply as a filter on the material data source.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question