Skip to Content
0

Design Studio - Validation of the input entered by the user for a variable

Nov 29, 2016 at 01:11 PM

322

avatar image
Former Member

hramyadevbvbdesing-studio.pngc024000t019310windowsupm-profiledesktopdesing-stud.txt

Hello,

I have issue in design studio as described below

1.My report has a variable in which the user enters the free text 2. Based on the free text entered by the user, all the policies which contains this text should be displayed.

3. But the design studio validates if the free text entered by the user is present exactly the same in the cube.

4.Can anyone suggest how we can turn off this validation of the input entered by the user against the transactional data.

5. I have maintained the required settings in infoobject, mutliprovider. It behave as required when I run the query in rsrt2 and also in WAD.

6.This issue is only in design studio. The attached document has a example.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Tammy Powlas
Nov 29, 2016 at 01:37 PM
0

Why would you not want the variable to be validated?

If that is the case, why not use a text box instead?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 05, 2016 at 07:15 AM
0

Hello Tammy,

We want the variable not to be validated as it is a special case for few reports.

We have BADI written in the backend for this variable to display all the records which contains the text entered by the user in this variable.

For this special purpose, we do not need the validation.

thank you.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 05, 2016 at 03:04 PM
0

Hi Ramya,

You can use a work around in design studio to find if it is a valid value or not like below.

1. Generate list of all available values in infoobject.

var members = DS_1.getMembers("DIMENSION", 1000);

var list="";

members.forEach(function(element, index) {

list=list+members.internalKey+";"; } });

2. Find whether the object has that value at-least once.

var validation=list.indexOf("user_input") ;


If the user given value is invalid, the value of variable validation will be "-1"

But to validate the value you have to use an input filed to get value and after validating you can set value for variable using script.

Thanks,

Poovarasan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 12, 2016 at 12:25 PM
0

Hello Poovarasan,

Thank you.

But in my case I do not need the validation in the input screen where we enter the input for variables.

thanks & Regards,

Ramya

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 14, 2016 at 06:49 PM
0

Hi Ramya,

Then you can use input filed to just get the value from user rather than using variable input screen.

So it will not do any validation with data, and you can get and pass the value using script.

If you want the same look and feel,you can use a panel component. Use input field for user input and a text box for title.

Thanks,

Poovarasan

Share
10 |10000 characters needed characters left characters exceeded