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
Mustafa Bensan replied
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.