My situation: There is a work database. Every day it is copied to another database named RetailDB. Fact and dimension tables of SSAS are based on VIEW-objects of tables in RetailDB. So, I have this ...
Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
I have a SSAS cube that has 2 perspectives. The second perspective is only used in a secured environment. I would like this perspective to be hidden when new users connect to the general populations ...