Skip to Content
0
Former Member
Jan 23, 2008 at 08:26 PM

Query Designer and Web Application Designer questions (BI 7)

30 Views

Hello gurus, I am trying to accomplish a few things using both they Query Designer and the Web Application Designer.

Using the Query Designer, I would like to have an exception that although will be based on specific values of one column, it will affect another column, also depending on its values. Maybe an example will work better...I have a query which returns a list of customers and how much they bought (expresed on $) on a given period of time. What I would like to do is have an exception that depending on the name of the customer and his total payments, will highlight with red, yellow or green the payment column. So maybe if customer A had payments for a total of less than $50 he will be highlighted in red, between $50 and $80 he will be highlighted in yellow, and over $80 in green. But customer B will be in red if his payments did not surpass $100, yellow if between $100 and $150, and green over $150. Is there a way to do this?? Also, is there a way to define variables so that they can either take one value, multiple values or a range of values, all using the same variable? Finally, some customer names are quite long, and they make the tables look huge. Is there a way to define a column size so that if the name is longer, the rest of the name is not displayed (or perhaps the column or table would contain arrows so that you can increase or decrease its size)?

With the Web Application Designer, I want to have a dropbox which besides showing you the individual values of a characteristic and giving you the option of taking all values, can either let you select (clicking) multiple values at once or at least give you the "select" option so that you can define there those values that you want to add. I read a thread about how to do this on BI 3.5, but I have unsuccessfully applied the solutions provided there on BI 7. Also, I have tried to have a filter pane show only some of the characteristics taken from its data provider, but my problem is that when trying to select those characteristics I can't see the whole list, I only see a few of the characteristics from the data provider, missing several that I want shown. How can I achieve this?