How to reset the value of drill down - Chart

[Former Member]

Hi gurus. I have a problem related with drilldown.

is there any way I can reset the drill down value?,of course, except for using reset button

(in this case "reset" means "make the cell blank of certain value")

I tried using "push button" and the cell is reset.

However, even though the cell is reset, the cell is set to the drill down value in one second.

ex. Drill down destination : a --> "" --> a

(a is drill down value)

Is there a way to reset the drilldown value?

Thanks in advance.

[johnbaxter · Accepted solution]

If you have not yet resolved this, can you provide more information? What is your University and position? What SAP application are you using? Where specifically in the SAP application is this issue occuring? Does it happen every time, or is this a one time issue?

John Baxter

SAP University Alliances North America

[Former Member · Accepted solution]

Hi, John Baxter.

I'm sorry for information i explainn and i'll explain another information, Of course i have not yet sorved this issue

1.

What is your University and position?

I'm graduate korea university and my position is EIM consultant.

2.

What SAP application are you using?

I'm using sap bo xcelsius 2008 sp3 and sap bw query as a database. (xcelsius <-> bw)

3.

Where specifically in the SAP application is this issue occuring?

Of course it is occuring in xcelsius application but i think this is the issue of pre-installed flex component.

Anyway, Although i made some excel function made cel to blank(""), the xcelsius chart remain the drilldown value.

ex) drilldown chart -> 1 -> select value using combobox -> "" -> 1

that means the xcelsius chart remain the drilldown value without refreshing drilldown value.

4.

Does it happen every time, or is this a one time issue?

Of course it's everytime issue. When I click drill down chart it happens. I have found similar questions but they are all not answered. Should I develop custom-component , using flex ?

i'm waiting your response. Thanks.

SAP BO xcelsius Consultant Kwon.

Edited by: rnjstnsdn on Oct 13, 2011 8:14 AM

[Former Member · Accepted solution]

Dear Kwon,

what you can use instead of the reset button (that is resetting all charts) is a push button.

The push button can insert blanks into the area that is filled by the drill-down option from the chart, if you want to reset this area.

Regards

Sonja

[Former Member · Accepted solution]

Thanks for your help , Sonja

I used push button but it can not refresh(reset) drill down cell

because the destination cell of the chart remains drill down value

I tried like below way

• a : drill down value

• Goal : make drill down cell turn to blank after i used drill down once.

1ST.

when i click the chart and use drii down, a is entered into drill down cell

2ND

by using "push button", i tried to reset drill down cell

but unfortunately it does not work.

Although drill down cell changes instantly to blank after just one second, it changes to a, drill down value

drill down cell changes like this

1 -> 2 -> 3

a -> blank -> a

i have to eliminate (2->3) phase or find another way to refresh drill down cell.

Regards

Kwon