Xcelsius drill down problem.

[Former Member]

Hi gurus, I'm developing drill down chart and table.

I want to reset, making cell blank, the drill down cell when i click combo box.

I used push button to refresh or reset drill down value 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

*Dashboard explanation

this dashboard consists of one chart, one table, one combo box and one push button.

Of course, chart has the drill down function

• 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.

I think problem is the chart which remains drill down value(a) although pushbutton reset the drill down cell to blank.

Is there any way to refresh or reset drill down value when i click combo box?

Should i develop custom-component? i'm waiting for your answer.

Thanks in advance.

Regards

Kwon

[amit_mathur · Accepted solution]

Hi Kwon,

Xcelsius components does not clear the previous selection and its by design. It would work if you use RESET button, as it would reset the components. The Push button would just replace the source data for the chart, not reset the component to clear the previous selection.

You can consider creating a custom chart to clear the previous selection.

Thanks,

Amit

[Former Member · Accepted solution]

Thanks Amit.

Actually I suppose that push button can not rest the component.

Maybe I should develop cistom component...;

Thanks.

Regard Kwon.

Edited by: rnjstnsdn on Oct 17, 2011 3:22 AM

[Former Member · Accepted solution]

Amit,

Can you confirm if what you're saying also holds for components with the "Enable Drill Down" option enabled, and the "Default Selection" is set to "No Selection (-1)"?

I'm running into an issue where the "Default Selection" value is not cleared out after performing 3 levels of drill-down. On the third time I do a drill-down, by default the first element is selected, even though I've set the "Default Selection" to "No Selection (-1)".

Thanks.

[Former Member]

This is by design but there should a workaround for issues in which internal memories are involved.

I use the easiest way of releasing the memory held in the component by purging it.

For this I use an extra empty query to clear data, and then add the actual data source into it again.

I havent tried with Drill down but pretty sure, if you clear the memory of the component and reload it, then it will once again default to no selected value