Skip to Content
0

subtotals is appearing in crosstab when multiple drilldown happens in the dashboards

Sep 07, 2017 at 11:29 AM

63

avatar image

Hello,

We are facing big issue in crosstab. When multiple drilldown happens in the dashboard.

we are getting subtotals in the crosstab. we have done the following settings,

1. hide subtotals for dimensions in the edit Initial View.

2. Using script, we have hide/show the total,

DS_1.setTotalsDisplay("_kMkwtbPyEeW186-SA4dmiQ", TotalsDisplay.HIDE); // this is to remove Subtotals appearing by default

But still we are getting the subtotal issue. Please find the screen shot,

Please help me on this.

Regards,

Vidhya.C

10 |10000 characters needed characters left characters exceeded

Hi Vidhya,

What type of data source are you using? Going by the technical ID format of your dimensions I'm guessing it's either a Universe or a HANA View.

How are you performing the drilldowns in the Crosstab?

Regards,

Mustafa.

0

Hi Mustafa,

Thanks for your response.

we are using universe. And drilldown will happen in the dashboard level not in crosstab.

we have many events in the dashboards like,

1. dropdown change

2. radio - on select

3. text change

so based these events crosstab will work.

Regards,

Vidhya.C

0

And the subtotals definitely do not appear in the Edit Initial View screen for the dimensions in question?

0
Yes...

I updated there also.

0

Just out of curiosity, can you post a screenshot of the data source Initial View without subtotals that corresponds to the Crosstab screenshot?

0

Please find the below screen shot, we have two dimensions (Parent and Child).

1.Parent

2. Child

0
Show more comments

Yes you are right Mustafa.

But the problem is even I do this setting and writing the code in script for Data source to hide subtotal. But still subtotal appears in the crosstab.

It may browser issue?

Regards,
Vidhya.C

0

Hi Vidhya,

We will not be able to confirm if this is a browser issue, Crosstab issue or other bug unless you can display the data result set in the Initial View preview for testing purposes.

Regards,

Mustafa.

0

Hi Mustafa,

Please find the attached edit intial view screenshot,

And also we have found that, while user click on sorting icon in the crosstab for different columns continually , subtotals is getting

appears. Please let me know, you have any idea on this.

Regards,

Vidhya.C

0

Hi Vidhya,

It looks like the two dimensions in the rows have identical values. Can you clarify that?

Mustafa.

0

Yes... It is like a Parent and Child dimensions...

0

Yes but in a parent-child relationship there should normally be multiple children per parent and even if there is only one child per parent, the child values should be different to the parents and not identical.

0
Show more comments

Hi Mustafa,

how to capture the sorting event in crosstab?

Because user is doing multiple times sorting in the crosstab. So that subtotal is appearing.

Please me on this.

Regards,

Vidhya.C

0

Hi Vidhya,

There is no direct way to capture a Crosstab sorting event. You could check if sorting triggers the "On Result Set Changec" event of the data source connected Crosstab.

Regards,

Mustafa.

0

Thanks for your reply.

Let me try out.

Regards,

Vidhya

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers