Using Pull-Up-function combined with ORDER BY with more then one dimension/columns

Question

Hello,

I had the PQL Code for Pull-Up-function in progress for many months now. This Function contains two dimensions/columns in the order by statement:

PU_LAST(DOMAIN_TABLE("TAB1"."ID"), "TAB1"."STATUS", order by "TAB1"."SORTING","TAB1"."TIMESTAMP") ='Anlage'

THEN 'create'

A few weeks ago after adding more records to the dataset I got the following error message:

Sorry! Something went wrong

We couldn't find any data for this chart

Pull-Up-function could not be executed PU_LAST:

Only one ORDER BY column allowed, but b2] columns were specified

After I removed the second Order by statement ("TAB1"."TIMESTAMP") the code works. However, ordering across both columns is still required.

Was there an adjustment (function) or could it have something to do with the new data import?

br Stefan

Page 1 / 1

Do you have access to the old dataset. I would always try to reload that into a test data model to see if that is the source of the issue.

Thanks for replay, I will try to reconstruct the issue.

sunny.thind · Answer

Do you have access to the old dataset. I would always try to reload that into a test data model to see if that is the source of the issue.

Sign up