Adhoc report selection

[#1]

Hi Community,

I am creating adhoc report which have multiple Dimensions and Expressions but my requirement is User should not have selection more than 10(Dim) / 10(Expr).

Ex:

User can Select maximum 10 only if he select more than 10 dim or 10 expr then error message should appear like 'You have selected more than 10'

[kaushiknsolanki]

Hi,

Use the calculation condition in "General Tab" under chart properties.

You can give condition as below.

if(Getselectedcount(Dimension) or GetSelectedCount(Expression) >10,0,1)

Here Dimension and Expression is the field from which user will select the Dimension and Expression.

Regards,

Kaushik Solanki

[Peter_Cammaert]

In your Chart Properties->General->Error Messages, define an error message for condition "Calculation Condition Unfulfilled". You can use something like "Only max 10 Dimensions or Expression selections allowed". This message will be displayed if the Calculation Condition returns false.

Now in Chart->Properties->General->Calculation Condition, enter something like:

(GetSelectedCount(DimensionSelectionField) <= 10) and (GetSelectedCount(ExpressionSelectionField) <= 10)

and you're set.

Peter

[#4]

Hi Peter,

but user shoul select atleast one and not more than 10

[Peter_Cammaert · Accepted solution]

Then the Calculation Condition becomes:

(GetSelectedCount(DimensionSelectionField) <= 10) and (GetSelectedCount(DimensionSelectionField) >= 1) and (GetSelectedCount(ExpressionSelectionField) <= 10) and (GetSelectedCount(ExpressionSelectionField) >= 1)