XI Dynamic Prompting

[MFritts253]

I am trying to figure out how to dynamically prompt the user for something like the Following. (The prompting is used to handle our organization hierarchy at any point in time)

They user will pick a date and company level like WHOLE COMPANY,EXECUTIVES,DIVISIONS,REGIONS,STORES this will filter
what underlying numbers the third drop down will display. Like this
COMPANY 01
EXECUTIVE 02/03
DIVISION 004/005/006
REGIONS 0100/0200/0300/0400
STORES 1000/2000/3000/4000

My numbers and company level are all stored in a table. So if the user SELECTED STORES the last drop down would only display the stores values which are in my table.


Cheers,

 

[MFritts253]

I solved this one on my own.

 

[lbass]

It might be helpful to others if you shared your solution.

-LB

 

[MFritts253]

How i fixed this, well i didn't really fix anything. I just didn't have any proir knowledge of Business Views and how to use them. I was looking for some help on where to start but i figure it out by setting up my database connections, using the data foundation next, the use business element, then create the business element view and then finally create a list.

If any would like specifics just ask.

Cheers,