Question Re: How apply background De-active filter using Dimension Filter ? in Technology Q&A

How apply background De-active filter using Dimension Filter ?

chandrasekhar6 — Thu, 17 Nov 2016 17:37:32 GMT

Hi Experts,

Suppose I have a single data source name DS_1 and I applied DS_1 source to both chart and Crosstab as below,

When I selecting Year filter from Dimention filter only chart changed depends on year and crosstab don't change.

How to De-filtering to crosstab component.

thanks,

Sekhar

Re: How apply background De-active filter using Dimension Filter ?

TammyPowlas — Thu, 17 Nov 2016 18:09:58 GMT

I am not following and I cannot recreate this issue

Are you saying you filter only the chart filters, and not the cross tab? The numbers for California look the same to me.

Please also clarify, and share version of Design Studio

Re: How apply background De-active filter using Dimension Filter ?

chandrasekhar6 — Thu, 17 Nov 2016 18:15:53 GMT

Hi Tammy,

Yes, filter apply only the chart filters and not apply to crosstab.

Design studio version 1.6

Thanks,

Sekhar

Re: How apply background De-active filter using Dimension Filter ?

TammyPowlas — Thu, 17 Nov 2016 19:01:14 GMT

Please share an image of your outline and properties of the application in Design mode

I can't replicate it on 1.6 SP2

Re: How apply background De-active filter using Dimension Filter ?

MustafaBensan — Fri, 18 Nov 2016 00:54:06 GMT

Hi Sekhar,

If your requirement is that you only want to apply the Year filter to the chart and not the crosstab as well, then you will need to duplicate the data source and assign the copy to the crosstab. The Dimension Filter should then only target the first data source which is assigned only to the chart.

Regards,

Mustafa.

Re: How apply background De-active filter using Dimension Filter ?

Former Member — Fri, 18 Nov 2016 01:08:30 GMT

you can set two datasource use the same universe,one is banding to crosstable,one to chart.and then set filter to datasource you want.

Re: How apply background De-active filter using Dimension Filter ?

chandrasekhar6 — Fri, 18 Nov 2016 12:37:00 GMT

Hi Mustafa,

Thanks for suggestion.

I used duplicate Data source then application loading is very slow.

Thanks,

sekhar

Re: How apply background De-active filter using Dimension Filter ?

chandrasekhar6 — Fri, 18 Nov 2016 12:44:35 GMT

Hi Tommy,

Please find following screen shots,

Outline,

App Properties,

Thanks,

Sekhar

Re: How apply background De-active filter using Dimension Filter ?

chandrasekhar6 — Fri, 18 Nov 2016 12:45:41 GMT

Hi Jing

Thanks for Suggestion

Thanks,

Sekhar

Re: How apply background De-active filter using Dimension Filter ?

Former Member — Fri, 18 Nov 2016 13:42:13 GMT

Hi Chandra Sekhar,

For your requirement, you can do data selection in chart rather than filtering and show the crosstab without filtering.

Thanks,

Poovarasan

Re: How apply background De-active filter using Dimension Filter ?

MustafaBensan — Sat, 19 Nov 2016 12:52:15 GMT

Hi Poovarasan,

As far as I know, the data selection option will only work for dimensions that are actually included in the data source Initial View. In Sekhar's example, the desired filter dimension, Year, is not included in the data source initial view, so I don't think the chart data selection option is applicable.

Regards,

Mustafa.

Re: How apply background De-active filter using Dimension Filter ?

MustafaBensan — Sat, 19 Nov 2016 12:55:15 GMT

Hi Sekhar,

Yes, unfortunately duplicating the data source will impact performance. However, I can't think of an alternative, more efficient approach to achieving your requirement. Is there a reason why the Year filter should only apply to the chart and not the crosstab? It would seem to me that for consistency of comparing the chart to the crosstab data, the Year filter should be applied to both.

Regards,

Mustafa.

Re: How apply background De-active filter using Dimension Filter ?

Former Member — Mon, 21 Nov 2016 07:43:56 GMT

Hi,

Yes the year object have to be in rows are columns to use it in data selection.

But we can customize the crosstab using css to show only result of year right. Sorry if i confused you in my previous answer I have added my complete answer with screen shot

We can have initial view of data as in above image.

Then we can hide the columns not needed in crosstab and use data selection in chart.

The CSS i used to hide columns in my crosstad is

.sapzencrosstab-DataArea tbody tr td:NTH-CHILD(1), .sapzencrosstab-DataArea tbody tr td:NTH-CHILD(2),

.sapzencrosstab-DataArea tbody tr td:NTH-CHILD(3), .sapzencrosstab-DataArea tbody tr td:NTH-CHILD(4),

.sapzencrosstab-DataArea tbody tr td:NTH-CHILD(5), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(2),

.sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(3), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(4), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(5), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(1)

{ display: none !important; }

Let me know if anything need in it.

Thanks,

Poovarasan