This script will replace all the zeros in the scenario Actual with #Missing, thus reducing the size of the database. After running script, must do a dense restructure. SET UpdateCalc Off; Actual = Actual / (Actual != 0);
Month: December 2018
Smart View Error: Invalid axis type for dimension Entity
Encountered the error "Invalid axis type for dimension Entity" in Smart View at a client. I had never seen this error before and couldn't find anything when I googled it. I was able to sit with a user experiencing the issue and quickly saw what the problem was. The EPBCS application was using the Financials … Continue reading Smart View Error: Invalid axis type for dimension Entity