Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having multiple dimensions for which I want to make as read only .
I am having the expression where I am using the calendar control for getting data between two dates like startdate and enddate and showing aggregation data in the report.
Please suggest how can I implement in my scenario ?
May be use set analysis in your expressions to restrict selection in those dimensions where you don't want the selection to impact your dimension
Do not make those dimensions available in list box format.
Check the ReadOnly option in Straigh Table Properties->General.
Now only the calendar selection objects will control the output in your straight table.
try this
=If(getselectedcount(Dim)>0)
or
in expression tab try to create dummy dimension with ur dimension value
lik Dim ,as Dim1
and make it representation as link.. so it will not allow to select