In SAS Management Console, the Authorizationtabs of cubes and OLAP schemas display the permissions that apply to those objects. With appropriate permission, you (the OLAPadministrator) can grant or deny Read or Write permission to users, roles, and groups. You can also control access to cube data, so that a single cube provides different data for different users. You can prevent access to specified dimensions, hierarchies, and levels, and you can define permission conditions to filter cube data within dimensions. To set permission conditions on a cube, use the MDX Expression Builder in SAS Management console, or open the cube's Authorization tab in SAS OLAP Cube Studio. For details and procedures, see the “OLAP Member-Level Permissions” chapter in the SAS Intelligence Platform: Security Administration Guide. 是不是因为一开始login进入的dimension和之后的dimension level不一样,直接从某些level/dimension pull data的话,会导致被block?
我在Excel建了一个自动化的报告,用了几次之后,就有问题了,每次刷新会一直弹出窗口,让我输入login credentials。但是输入了也没有用,窗口会继续弹出来。后来我研究一下,发现估计是连接Olap Cube哪里出了问题?我觉得应该是权限方面的问题,导致刷新就算输入了credential也不管用,但是我重新开一个Excel连接新的connection的话,又没有任何问题。。 有了解Olap的人可以指教一下到底是什么原因?
是不是因为一开始login进入的dimension和之后的dimension level不一样,直接从某些level/dimension pull data的话,会导致被block?