Adhoc Reporting

[#1]

Hi,

I have been trying to impplement adhoc reporting, i have tried using substringcount function like below to populate the dimension fields into the chart in the enable condidition as -substringcount(concat(Dim_Name,'|'),'CASE'),but in this case when the dimension Case is selected another dimension Case_Type also appears in the chart.So even though the chart needs to be populated only with case dimension ,it gets populated with case and case_type.Please let me know how this could be resolved to get the desired results

[jsingh71]

Hi Anushri,

I also face the same issue some days back. To resolve this issue rename your dimension name in inline load. I solved mine using this only. If still facing the same then load sample app.

[SunilChauhan]

see the Report Tab in attached file

[tresesco · Accepted solution]

In such case an extra character would be required to separate out the difference like:

=substringcount(concat(Dim_Name &'@' ,'|'),'CASE@')

[sasikanth]

Hi ,

Please find the attachment ,

it will guide you

[SunilChauhan]

see the Report Tab in attached file

[cheburashka]

Hi,

For an out of the box (no scripting to create the dimensions) Ad Hoc table solution. Feel free to check out this document.

,KR Koen