TM1 Forum

Hi,

user wants to input the data from excel so i am using dbs, if user enter invalid element we have to popup error message.

See below some key points and let me know your valuable suggestions,it could be very helpful if anyone sends an answer.

Regarding logic of validating the element in the dimension:
• Excel IF statement
• Check if Input is NOT equal to blank (i.e. A1 <> “”), if so, show blank
• Check if Dimension Element exists (i.e. DIMIX( DIMENSION_NAME, A1) = 0) ), if not, show string “ERROR – No Such Element”
• In addition, the “Upload” action button will further validate the data, it should pop up an error message if user enter invalid data (i.e. incorrect element name)


Thanks,

What kind of suggestions are you looking for? Do we think it is a good idea? I would say that it appears reasonable. However, I would put the "validaton" cell next to the cell with the DBRW formula and skip the IF idea. Use conditional formatting to indicate an error. You can use an "Upload" button but that's going to mean writing VBA. Why write VBA if you don't have to? Not to mention the form won't work in TM1Web if you use VBA.

tomok wrote:What kind of suggestions are you looking for? Do we think it is a good idea? I would say that it appears reasonable. However, I would put the "validaton" cell next to the cell with the DBRW formula and skip the IF idea. Use conditional formatting to indicate an error. You can use an "Upload" button but that's going to mean writing VBA. Why write VBA if you don't have to? Not to mention the form won't work in TM1Web if you use VBA.

When iam trying to write conditional formatting in formaula bar it was disabling not only conditional formatting every option disabling. I am new to tm1 as a fresher please dont angry on me.
my formula is
if(and(dimix(dimname,elename)=0),dbs(reference cell value,cube,dim's),"")here i have to show error message if user enters invalid element.

Hello

venkatcgn3 wrote: When iam trying to write conditional formatting in formaula bar it was disabling not only conditional formatting every option disabling. I am new to tm1 as a fresher please dont angry on me.
my formula is
if(and(dimix(dimname,elename)=0),dbs(reference cell value,cube,dim's),"")here i have to show error message if user enters invalid element.

It seems that you are also new to Excel. Conditional formatting is not in the formula bar, it's a menu option in Excel.

Put in a cell:

=dimix(dimname,elename)

and color the cell red.
Then use conditional formatting to format one or more cell based upon the value of the previous cell: color it green it the result > 0.