dbTalk Databases Forums  

URGENT: problem with dimension members security in russian!

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss URGENT: problem with dimension members security in russian! in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alexander Nenashev
 
Posts: n/a

Default URGENT: problem with dimension members security in russian! - 05-05-2004 , 03:20 AM






hello, ppl.

i have problem when i use russian language to build AS database.
(all cubes, dimensions, members are named in russian).
the previous db in english was working fine.
i used roles to restrict access to 'Products' dimension.
(each manager has access only to his product group).

when i created roles in the russian db, all ppl restricted by 'Products'
dimension has only error values in queried cellsets.

i thought AS supports unicode well,
what could be a problem?

alexander.



Reply With Quote
  #2  
Old   
Alexander Nenashev
 
Posts: n/a

Default Re: URGENT: problem with dimension members security in russian! - 05-05-2004 , 05:04 AM






i made virtual english dimension WareSecurityGroup (belonging to Product
dimension)
and built member security with it.
works nice, but what is a problem with russian dimension?

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> сообщил/сообщила в новостях
следующее: news:uj$DEFnMEHA.2628 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Quote:
hello, ppl.

i have problem when i use russian language to build AS database.
(all cubes, dimensions, members are named in russian).
the previous db in english was working fine.
i used roles to restrict access to 'Products' dimension.
(each manager has access only to his product group).

when i created roles in the russian db, all ppl restricted by 'Products'
dimension has only error values in queried cellsets.

i thought AS supports unicode well,
what could be a problem?

alexander.





Reply With Quote
  #3  
Old   
Alexander Nenashev
 
Posts: n/a

Default Re: URGENT: problem with dimension members security in russian! - 05-05-2004 , 07:00 AM



hmm... also errors

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> сообщил/сообщила в новостях
следующее: news:u7S$B$nMEHA.2976 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Quote:
i made virtual english dimension WareSecurityGroup (belonging to Product
dimension)
and built member security with it.
works nice, but what is a problem with russian dimension?

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> сообщил/сообщила в новостях
следующее: news:uj$DEFnMEHA.2628 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
hello, ppl.

i have problem when i use russian language to build AS database.
(all cubes, dimensions, members are named in russian).
the previous db in english was working fine.
i used roles to restrict access to 'Products' dimension.
(each manager has access only to his product group).

when i created roles in the russian db, all ppl restricted by 'Products'
dimension has only error values in queried cellsets.

i thought AS supports unicode well,
what could be a problem?

alexander.







Reply With Quote
  #4  
Old   
Alexander Nenashev
 
Posts: n/a

Default Re: URGENT: problem with dimension members security in russian! - 05-05-2004 , 07:35 AM



that problem occurs only with virtual cubes

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> сообщил/сообщила в новостях
следующее: news:uj$DEFnMEHA.2628 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Quote:
hello, ppl.

i have problem when i use russian language to build AS database.
(all cubes, dimensions, members are named in russian).
the previous db in english was working fine.
i used roles to restrict access to 'Products' dimension.
(each manager has access only to his product group).

when i created roles in the russian db, all ppl restricted by 'Products'
dimension has only error values in queried cellsets.

i thought AS supports unicode well,
what could be a problem?

alexander.





Reply With Quote
  #5  
Old   
Alexander Nenashev
 
Posts: n/a

Default Re: URGENT: problem with dimension members security in russian! - 05-05-2004 , 07:39 AM



found !!! no language but virtual cubes problem.
details later...


"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> сообщил/сообщила в новостях
следующее: news:uj$DEFnMEHA.2628 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Quote:
hello, ppl.

i have problem when i use russian language to build AS database.
(all cubes, dimensions, members are named in russian).
the previous db in english was working fine.
i used roles to restrict access to 'Products' dimension.
(each manager has access only to his product group).

when i created roles in the russian db, all ppl restricted by 'Products'
dimension has only error values in queried cellsets.

i thought AS supports unicode well,
what could be a problem?

alexander.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.