BO4 - IDT tool @prompt in join nor working - any ideas?

[former_member272336]

Hi We have a .unv with a join defined as

table.column_name = @prompt('Enter currency required','A','ClassName\ObjectName',Mono,Constrained)

Works fine in .unv but nor  in .unx

Converted the .unv to the .unx

Any ideas?

Thanks

[Former Member · Accepted solution]

Hi Philip,

Could you please provide the error message and the workflow to receive error message in IDT?

Thank you

Hyder

[former_member272336 · Accepted solution]

Hi Hyder,

We convert .unv to .unx via IDT tool including checking the box for @prompts.

Error message when parse the self join is invalid expression.

If I substitute 'ClassName\ObjectName' for a hardcoded list of values

{'GBP','EUR'} then parses fine.

Thanks

[Former Member · Accepted solution]

Hello Philip,

Self joins defined within the tables may not consider syntax as the classes and objects do not exisits in the data foundation.

When the universe is converted to unx or if you manually define the self join(filter) in unx under the data foundation it does not give u an option to select an object from class as these are only created in Business Layer.

The only option I see here is to manually associate a staic list of values from Parameters and List of values within the data foundation

Regards,

Laxminarayana

[former_member272336 · Accepted solution]

Hi,

Do you have  more details hwo to do this?

Thanks

Philip

[Former Member · Accepted solution]

Hello,

1.Go to the data foundation and you will find a tab on left side down 'Parameters and List of values'. Select it

2. Now go to the List of values

3. ON the top left you will find a small icon(with a green +symbol). click on it and select 'List of values based on CustomSQL'

4. Edit sql on the right side and define the sql for which you want the list of values

5. Now go to Parameters( you will see his above the list of values Window)

6. Insert a prompt by clciking on a small icon on left side

7. Give a name and prompt text

8. Under List of values click on the small icon(with .. symbol on right side) and select the lsit of value defined in step3

9. Go back to the connections in Data foundation and select the filter defined for the table or insert a new filter

10 Click on the sql assitant icon and define the prompt by selecting  the prompt from the parameters

for ex:

"<Tablename>"."<Column name>"=@prompt(<parameter name defined>)

Hope this helps:)

Regards,

Laxminarayana

[former_member272336 · Accepted solution]

Hi Laxminarayana,

Thanks very much for your help.

Thanks

Philip