I'm working on building a data model/calculated view on SAP HANA DB. And I was in need of a dummy table which is not linked to the fact table. When I run the model, it started throwing an error that there is an issue with the logical table join. I had used the dummy table to switch between current value and historical value of a measure
Asked
Active
Viewed 34 times
0
-
It sounds like in SAP HANA there is. – Nick.Mc Jan 08 '20 at 12:16
-
1What do you mean by “switch” between historical and current measure values? Do you mean filter records based on a date? – Lars Br. Jan 09 '20 at 00:23
-
"switch" does help in converting the base currency to either the exchange rate of past quarter or to the current quarter – Arvind Jan 10 '20 at 03:29