Hi Everyone,
I have a requirement like this.I have Region Dimension which will have data like US,UK,AUS.
But in Xcelsius dahboard i need a Region Drop down with region data along with 'ALL' Option.
So,when i select ALL it has to sum up all regions data and to show it the graph.
I thought of creating a ALL Dimension and doing a unoin with region Dimension in universe.
Since ,the source is Sap Infocube twe cannot edit the LOV.
I tried other option also,i.e using matches pattern for that also we can not give(%) default value.
So,Please help me anyone who come across these type of situations.
Thanks in advance.
Siva