Hi. I encounter this error when I drag Forecast into the Data Visauliser Workbook:
State: HY000. Code: 22073. [nQSError: 22073] Internal Error: (Generation of physical plan for dimension query failed with (HY000)
State: HY000. Code: 42064. [nQSError: 42064] Incorrect dimension specified for TimeDimSeqNum function. TimeDimSeqNum function should take columns from one time dimension.).
However other timeseries functions work like AGO & PeriodRolling on the same Subject Area.
I only have a single Time hierarchy. I created a whole new Business Model & Subject Area to test it wasn't to do with orphaned objects.
Facts are pointing to the time hierarchy at the month level (amounts are only aggregated to month-level). Hierarchy is simple Year > Month. Proper Chronlogical Keys set. Facts is joined to Timeseries (Right Outer).
Any ideas?
