No Data Chart Displays error message In Design Studio

[manjula_muniveerappa]

Hi All,

I am trying to build an application with 5 levels.  Where user can drip down or drill up from one to other level

1) Region Bu

2) Plant

3) Plant Section

4) Unit

5) Month.

and its implemented using tabs and every tab has 3 to 4 chart based on the selected values Data will be filtered and charts will be
displayed.

When we have a data everything works fine but when we don't have a data for the selected criteria it shows the message saying “Cannot display
chart, No Data Available due to filter setting”

Please let me know how I can displayed the empty chart with the message as No Data or do we have any other way of communicating this to user
since this looks like something is broken.

Thanks,

Manju

[jeroenvandera · Accepted solution]

Hi Manjula,

If you want the users to only select filter combinations that actually have data apply the filter to a datasource and refill the other components using the .getmemberlist() method of the datasource. That way you can limit the options to only those that actually provide data.

If the requirement is that users should see when there are no records. you can for example use the .getdata() method of the datasource to determine if there is data present. When a user clicks on a tab you run the getdata() to check if there is data present. If not you hide the graph components and unhide a text component that informs the user that the current selection holds no data. That way you have a nicer way to tell the same message.

kind regards,

Jeroen

[bharathsap · Accepted solution]

Hi Jeroen,

That's a good suggestion.

Former Member  We are coming up with a function like "isResultSetEmpty" (in 1.2) using which you can trigger events like hide chart if result is empty.

Regards,

Bharath

[shlomi_weiss2 · Accepted solution]

Hi Bharath,

I'm using D.S 1.5 SP1

and I didn't manage to use the new isResultSetEmpty event

Can you explain in a few words how and where to use it?

Regards

Shlomi

[Former Member · Accepted solution]

Hi All,

I have a similar Problem.

My Dropdown at the Moment is populated with all the Country values.However, there is no data corresponding to many countries and when they get selected the Charts definitely dont give a good presentation to the user.

I want only the Countries corresponding to which there is data in the backend to be filled up in the Dropdown.

Please can anyone tell me the exact script to write and where.

Reply Awaited.

Regards

Niyati

[TammyPowlas · Accepted solution]

This issue is different than Manjula's

If you are using BW as a data source, this setting to see only the values posted to is in the Business Explorer tab of the infoobject.

[Former Member · Accepted solution]

Hi Tammy,

I was following the answer of Jeroen van der A to manjula's problem. But I cant figure out the script ; where to write what.

At the moment all the values are there in the dropdown and for some the charts show the same error as attached by manjula.(since there is no corresponding data to the value selected in dropdown)

I am using BEx query as datasource and Value posted is already there.

Regards

Niyati

[TammyPowlas · Accepted solution]

I recommend creating a new discussion with your issue

On the one hand you are saying you are getting back all values, whether posted to or not (controlled by BEx)

On the other you are not getting any data

Please create a new thread

[Former Member · Accepted solution]

My dropdown at the moment consists of all the values from Country dimension.All the  countries are llisted.Upon selection of any particular country I see the data in charts.However there are some countries in the dropdown list for which I get "No data available".So what is required is only those countries for which there is data that can be shown in the charts,should be listed in the dropdown.

I think you misunderstood my requirement.

Have created a new thread now.

Regards

Niyati

[Former Member · Accepted solution]

Jeroen van der A wrote: 

If you want the users to only select filter combinations that actually have data apply the filter to a datasource and refill the other components using the .getmemberlist() method of the datasource. That way you can limit the options to only those that actually provide data.


Hi Jeroen,

I want to know the script and where to write the script for your above lines.I have a dropdown and a DS.

Regards
Niyati

[Former Member]

Hi Manjula,

What solution did you have for your Problem?

I have a similar Situation.

Regards

Niyati Shah