Service account and AD account that started the job have administrative permissions on both SSAS instances. Both source and destination SSAS instances are in the same AD domain, are running under the same AD service account. IP of source and destination are on the same sublet.
Source SSAS VM and Destination primary node VM are on the same HyperV cluster node. SQL cluster consists of two VM nodes (guest cluster). Destination SSAS instanse is on clustered SQL. Source SSAS instance is on standalone SQL. I have a sync DB problem between two SSAS 2014 instances that I cannot fix for some time. I hope I have described my scenario in sufficient, if there is anything unclear - please let me know. This attributes should only be available for a specific group of users. Our current Item-Dimension contains the attributes "Material Costs" and "Operational Costs". In this case, the default security concept doesn't fit. AD-Group "Bike-Manager of Testcompany": Should see only values of the Company "Festcompany" for the BA "Bikes". ThisĬan be done by the default dimension data security tab (Allowed Set: Visual Totals = True). For Example: - AD-Group "Company Manager": See all the data of the hole company "Testcompany", which can contains more than one Business area. Our currently organization requires, that the security depends on two different Dimensions.
What different options exits and can you recommend taking into account the query performance to solve this issue? I use a lot of calculated Measures on which the security cannot be realized by default. My scenario includes following requirements/problems: So I decided toĪsk the experts, you, for help, tips and your practical experience again. But to extract all helpful threads seems to be impossible :-). I know, that this topic was already discussed a lot of times before.