Excel Form Uploaded in PAX

Post Reply
manu0521
Posts: 43
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Excel Form Uploaded in PAX

Post by manu0521 » Thu Jun 13, 2019 8:39 pm

Hi Guys,

I have like an excel form created in excel with some basic validations on the sheet and loaded it to paw as a book .

Users will be able to enter the details in the form and I plan to have a submit button which write the value in a TI Process from the sheet in to a attribute cube .

I wanted to know is there a way to have 2 buttons and show the submit button only if all the entries are valid or have one button shown disabled initally and once the users enters all details and is valid enable the button .

Any help is appreciated as this one is new to me .

Emixam
Posts: 16
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: TM1 10.2
Excel Version: 2016

Re: Excel Form Uploaded in PAX

Post by Emixam » Fri Jun 14, 2019 2:15 pm

** I just realize my answer makes no sense to your question, however maybe it will help someone else **

Hello,

I don't think there's an easy way to do that. However, here's my suggestion:

In your Excel form, create a formula to validate if all the entries are valid (0 = No, 1 = Yes). Also, a conditional formatting (0 = red, 1 = green) can be a good way to easily show that not all the entries are valid.

In your TI, add a parameter (i.e., pValidation) and add the following code at the top of the prolog tab :

Code: Select all

IF( pValidation <> 1);
    ProcessQuit;
ENDIF;
You can also play with the Process Option to display messages.
Attachments
2019-06-14_10h14_26.png
2019-06-14_10h14_26.png (59.45 KiB) Viewed 115 times

manu0521
Posts: 43
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Re: Excel Form Uploaded in PAX

Post by manu0521 » Fri Jun 14, 2019 2:50 pm

Yes this is helpful . Thanks !! I will give it a try and let you know how it goes.

Post Reply