Hi,
My business model looks like this:
snaggy - paste images!
As you can see there are two table sources which are used for measure "balance"
The "balance" measure is simply difference: Quantity1 - Quantity2.
And I get following error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,[fct. account.Balance]]. (HY000)
SQL Issued: SELECT 0 s_0, "Operations"."Measures"."Balance" s_1 FROM "Operations" FETCH FIRST 65001 ROWS ONLY
What am I doing wrong?