adhoc reporting

[Shiva123]

hi,

       all i am trying to figure a logic for adhoc reporting, where in i have two different sets of attributes and one set of measures, the issue is when the user wants to selects any one of the attributes the chart should be displayed excluding expressions. right now i have a logic saying select all three of them, is there any logic to pick one attribute. any help would be great. i have done the basic requirements for adhoc reporting.

my expression is like this

GetSelectedCount (dimension set 1)>0 and GetSelectedCount (dimension set 2)>0 and  GetSelectedCount (expressions )>0

thanks

Shiva

[sunny_talwar]

May be you want this

(GetSelectedCount(dimension set 1) > 0 or GetSelectedCount(dimension set 2) > 0) and GetSelectedCount(expressions) > 0

[Shiva123]

this condition doesn't work @sunny , if i pick one dimension from dimension set1 and one measure, it is displaying  all the dimensions in dimension set  2

condition for dimesions

SubStringCount(Concat(Attribute, '|'), '$(=only({$ <AttributeNO={1}>} Attribute))')

conditions for expression

SubStringCount(Concat(Measures, '|'), '$(=only({$ <MeasureNO={1}>} Measures))')

thanks again

[sunny_talwar]

It might make is easy if you can share a sample of what you have....

[Shiva123]

attached is the app

[sunny_talwar]

Yes

[Shiva123]

i have attached the app

[sunny_talwar · Accepted solution]

Check the attached with the changes implemented

[Shiva123]

thank you so much  , again you are amazing man .....