BusinessObjects Board

How to implement Cascading filter dashboard??

other Xcelsius - Crystal Dashboard Design
#1

I need to implement cascading filter in dashboard using Crystal Xcelsius…

I have the req like this:

A-- ALL
A1
–A2
– A3

B – ALL
B1
–B2
–B3
–B4

When you select A and select ALL from corresponding second filter, then it should return all the values in A not B values.

rollings007 :poland: (BOB member since 2007-02-15)

Cascading Value in Combo Box
Can we create cascading list of values in Xcelius?
#2

HI I have perfect solution for this…You need to create derived table in the universe.If you know how to create logic your problem will solve.

Thanks
Rao.Marapatla

rao_marapatla :india: (BOB member since 2008-08-06)

#3

rao can you explain in more detail.

how do you implement dasboards using derived table

rollings007 :poland: (BOB member since 2007-02-15)

#4

Hi rollings007/rao_marapatla ,

can you please explain the same, as my manager is looking for this functionality in Xcelsius.

raju786 (BOB member since 2010-03-31)

#5

Hi,
please check my solution attached! You won’t need to look further ;-)!

Hope this helps.
cascading filters_all.zip (9.0 KB)

Luca Spinelli :it: (BOB member since 2008-08-27)

#6

Hi Luca,
This solution is too good. Thanks.
I have another requirement which I had posted in here Callling another tab
Any thought on it?

Philip (BOB member since 2006-03-02)