BusinessObjects Board

Many filters

building semantic layer
#1

Hello,

I have 5 filters. They can be set or not.
A set filter contains lov or * otherwise it contains nothing.

I see that prompt is not a valid solutions because it gets me to type a value.

I thought to create a report without filters and at the running moment call a VBA routine. This routine will built my SQL according to the filter settings.
Then I have to pass the SQL statement to BO (my report) and get it running.
The connection is RDO
Is it possible?

How can I fix my problem?
Thank you in advance …

Blinky (BOB member since 2005-02-23)

#2

I don’t get the

part.

The “Values…” button in your prompt-box lets you select the values, not? If not, then the LOV is disabled.

Or am I entirely out of scope and not understanding your question?

jobjoris :netherlands: (BOB member since 2004-06-30)

#3

I have 5 filters. They can be set or not.
I would like Filters not set is the default.

A set filter contains lov or * otherwise it contains nothing.

In case I’ve to set a filter no problem… because with prompt I can choose values.

The problem is when I don’t need that filter so I have not to set it.

Example:
if I’ve a these filters:

  1. City
  2. Type of shops (small,medium and big)
  3. Departments
  4. Employees
  5. Core business

I would be able to set filters like these examples

  1. City/Type of shops (others are not set)
  2. Type of Shops/department/core business (city and employees are not set)
  3. Type of shops/Departments (others are not set)

If the filters shouldn’t be set I don’t want to ask to enter/choose any value.

I hope it’s more clear now.

Blinky (BOB member since 2005-02-23)

#4

Blinky, I think the essence of your post is what is known as optional prompts. Inevitably, this also leads to a discussion of default prompts. Take a look at this post in another thread for guidance on that topic.

Could you re-build the data provider on the fly using VBA? Yes, but it’s kinda messy.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#5

Thanks Dwayne, I’ll try.

Blinky (BOB member since 2005-02-23)