Birst Fridays

Hello BUG!!!

Please use this discussion thread to post quesitons to be answered by our Birst gurus during the monthly Birst Fridays. They will make every attempt to answer all questions during the event but if that is not possible, someone will reach out to you as soon as possible.

Thank you and Happy Birsting

Find more posts tagged with

Comments

Lisa Callahan

Question: Is there a way to search through all the objects in the data model (variables, custom attributes, saved expressions, etc.) to find everything that is obsolete? I want to do some cleanup but the only way I know how is to document every dashboard manually wihch really is not a solution.

Lisa Callahan

Question 2: This refers to incident 15825293. I have both business translations that are specific to certain customers so use Customer Key as the identifier in the Visualizer/Subject Area Translation function. However, I also have localization that should be applied across all customers, regardless of their Customer Key value. I cannot figure out how to write a variable that says -

If Customer Key = -1 apply to all customers, If Customer Key <> -1 apply to that specific customer

And it has to be a variable to work with the process laid out - Metadata Localization and Business Translations for Reports (found in the help files).

Legacy Contributor

Unfortunately no.

Lisa Callahan

This is what I want it to do, but this is not possible in a variable. I want it to run a different SELECT statement based on a condition.

IIF(
[Language.Customer Key] > 0,
(SELECT [Language.ObjectName], [Language.MappedName] FROM [ALL] WHERE [Language.CustomerKey]=[Customer.Customer Key] AND [Language.Locale]=GetVariable('UserLocale$')),
(SELECT [Language.ObjectName], [Language.MappedName] FROM [ALL] WHERE [Language.Locale]=GetVariable('UserLocale$'))
)

Diane McElhiney

@lcallahan

Have you tried the use of EVAL?

Lisa Callahan

I tried this but it does not validate -

EVAL<!IIF([Language.Customer Key] > 0,'SELECT [Language.ObjectName], [Language.MappedName] FROM [ALL] WHERE [Language.CustomerKey]=[Customer.Customer Key] AND [Language.Locale]=GetVariable('UserLocale$')','SELECT [Language.ObjectName], [Language.MappedName] FROM [ALL] WHERE [Language.Locale]=GetVariable('UserLocale$')')!>

Copyright © 2025 Infor. All rights reserved.