BQL 2.0 Measure

Hi,
I'm trying to make a measure where I get the ordered quantity for the current year, but for some reason the expression below does not work out:

[PUDT: Sum: Ordered Qty_Procurement Analysis] WHERE [Time.Year]=GetVariable( 'Current Year')

Any suggestions?

Find more posts tagged with

Comments

Legacy Contributor

The Current Year variable works fine alone btw

Diane McElhiney

The error you are receiving may not be the GetVariable. You are trying to save an expression by a name which already exists. You can view the BQL being generated for the visualization by selecting the Tools icon and click Queries. Highlight the query and run in Query Admin as well as verify the Navigation path.

Legacy Contributor

It might be obvious from that screenshot, however the name was not the main issue. I'm sorry for not being more clear here. Thank you anyways!

Diane McElhiney

Based on your reply, it isn't clear whether the issue still occurs. Is Current Year a repository or session variable?

Copyright © 2025 Infor. All rights reserved.