BVM Cascading Prompts : Multiple parameters at same cascading level

[Former Member]

Hello,

Is it possible to have multiple parameters at the same cascading level?

For example, Family>Product>(License and Study ID).

Product cascades according to the Family. Both License and Study ID should cascade based upon the selection of Product.

Is this possible in BVM? If yes, how?

I have given a shot at this requirement in the following way(see image)-

Thanks,

Prasanna

[abhilash_kumar · Accepted solution]

Hi Prasanna,

No you cannot however, you can 'combine' the two fields - License and Study ID.

To do this, you would create a new formula that concatenates the License and Study ID at the 'Business Element' layer.

-Abhilash

[Former Member · Accepted solution]

Hi ,

Thanks for the update!

Is there any limitation on the number of rows that are returned or utilized in BVM? I have a query that returns 24K records in TOAD, but when i use the prompts based on the same query in Crystal as well as BVM(browse data at the field level in Data Foundation), I dont see all the values.. I checked publicly available BVM documentation, but could not find any limitation mentioned..

On a side note, I did read you reply on some other thread(http://scn.sap.com/thread/3453672) that Crystal Reports(2013) can show only 1000 values in the LOVs populated from BVM. However, I am not seeing the entire data in BVM browse data itself, hence the question!

Abhilash, thanks a lot for all your replies. You have been and will be a great help in our endeavor to explore BVM and Crystal Reports!

Thanks,

Prasanna

[abhilash_kumar · Accepted solution]

Hi Prasanna,

'Browse data' only has the ability to display about 500 unique values.

Please add the registry key as mentioned in the thread above to overcome the LOV limit.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I got the values changed and the tool now allows me to get 2500 LOVs for a parameter.
How to identify the relationship between --

The number of rows that the BVM query fetches( in TOAD, for example)

AND

The limit for LOVs ( 2500 in this case)

?

Thanks.

Prasanna Pathade

[abhilash_kumar · Accepted solution]

The registry key controls the how many values are displayed.

The query sent to the database looks like this:

Select Distinct table.field from table

-Abhilash

[Former Member · Accepted solution]

Hello ,

By concatenation, are you implying that we display both study and license in the same input parameter? For Eg. STUDYID-License ID, etc.

Can you throw some more light on the solution you are proposing?

Thanks,

Prasanna

[abhilash_kumar · Accepted solution]

Hi Prasanna,

Yes, indeed - you can display both the the StudyID and LicenseID in the same prompt.

E.g:

1234-LicenseXYX

-Abhilash