Dynamic Members Security

Hi All,
I have a working solution with user-defined security. When user connects to a cube, a list with allowed members is created(retrieved from table) and returned as set to AS. Everything works fine.

Problem is that members are retrieved only at connection time. When I change my table with allowed members later, I would like to force AS to re-read this information again. Of course I can restart AS service or do full process of cube.

Does anybody have an idea?

Thanks,
Radim

Have you tried just reprocessing the dimension affected? What are the specifics of the solution?

|||That's very correct. Processing is possible solution but since I have many concurent users I didn't want to disrupt them. But yesterday I played with it more and I discovered that it's only necessary to do Process index. That's enough to force re-read of allowed members.

Thanks for contribution.

Radim

Dynamic column width? Any way to do it?

Hi,

Is there a way to dynamically change the column width depends on the length of the data retrieved? Meaning, if I retrieve a number 11.0031243 or 11.3, it should fit into the column just nice with no redundant spaces. The width of the header should follows.

Is that possible?

Thanks!Ya its possible but u need to calculate the length of the retrieved field and accordingly u can adjust width of the column in Cystal Rpt...
Before that at the time of testing u need to confirm how many characters u can place in ur column field...
if u have any query abt this soln pls tell me....