reporting services - Allowing users from a non trusted domain to Dimension data -


domain = ssrs users domain b = ssrs , ssas instances

there around 5 separate roles segregate allowed member set in dimension data. domain user(s) cannot added ssas cube role(s) in domain b since domain not trusted domain b. best way enable ssas dimensional data level security user(s) domain a?

tia!

the straightforward solution move ssas server domain a. that's users are. plus, if it's in domain a, domain b users can connect since domain trusts domain b 1 way. highly recommend this.

if that's not option, might try this. in ssrs, should able set credentials on ssas data source use domainb\serviceaccount. should able pull ssas data ssrs.

to bake role based security ssas, see 2 options. first, might create 5 reports , use ssrs security control can see report. behind scenes, each of 5 identical reports use different service account on ssrs data source connect ssas. each use granted access 1 of 5 reports , report connect using 1 of 5 service accounts ssas , role based security in ssas show appropriate data 1 service account.

if that's not acceptable might consider using dynamic security using customdata since can't have domain users connecting ssas on domain b.

typical dynamic security uses 1 role mdx expression , username() mdx function lookup current user can access: http://hccmsbi.blogspot.com/2007/08/implementing-user-specific-security-in.html

your situation since can't connect ssas on domain b domain users, use customdata() mdx function instead of username() mdx function. may have use expression based connection string in ssrs. hardcoded connection string like: data source=ssasserver.domainb.local;initial catalog=yourdb;customdata=joeblow

the 1 role have have domainb\serviceaccount member. internally use customdata connection string property figure out "who are" , dimension members can see.

as far excel, i'm thinking setup 5 msmdpump virtual directories , in iis grant each domain user access one. however, i'm not clear on how work because don't know how setup iis impersonate domain b service account when connects ssas. had thought through this?

let me know if doesn't make sense. again, recommend moving ssas domain a.


Comments

Post a Comment

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

i'm looking dynamically populate select element names of items stored array. for reason it's not working , i'm not sure why. html: <div class="col-md-4 col-md-offset-4"> <select class="select1"> </select> , <select class="select2"> </select> </div> note i'm using bootstrap layout. here's jquery i'm using try , populate ".select1" jquery: select: function() { $.each(state.greens, function(index, value) { $(".select1").append("<option value =' " + index + " '>" + state.greens[index].name + "</option>"); }); } note function 'select' stored within object called 'display'. state.greens name of array i'm trying access. so @ end of html page call display.select(); call function. no error messages showing in console. also, saw question: appending
Read more

Android soft keyboard reverts to default keyboard on orientation change -

i'm building android soft keyboard , can't seem fix bug - have arabic , qwerty keyboard , when rotate device on qwerty keyboard (or arabic shift), it's if program has "restarted" , becomes arabic keyboard without shift. the onsaveinstancestate(bundle savedinstancestate) not work because application not extend activity inputmethodservice . i put following in android manifest android:configchanges="keyboard|keyboardhidden|orientation" android:windowsoftinputmode="stateunchanged|adjustresize"> i tried using @override public void onconfigurationchanged(configuration newconfig) { super.onconfigurationchanged(newconfig); log.i(mydebug, "config changed " + currentkeyboard.equals(qwerty)); } however, currentkeyboard.equals(qwerty)) results false , made sure true before orientation change. any appreciated. i think applications fault. if application restarting on orientation change
Read more

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -

i rendering jbutton image on simulate jcheckbox behavior. why don't let jtable render jcheckbox? because need bigger checkboxes , there's no way can resize them (as far know). so, have own table cell renderer , editor. both renders jbutton , checkbox images on them. trying change image checked image unchecked image (or vice versa) , update cell value (boolean true or false). however, reason, getcelleditorvalue() not update table. so, release mouse, value goes original one. any appreciated! lot! public class tableexample extends jframe { jscrollpane pane; jpanel panel; jtable table; object[][] data; mytablemodel tm; renderer buttoncolumn; public tableexample(object[][] data) throws ioexception { string[] columns = {"column#1", "column#2", "column#3", "column#4", "column#5", "column#6"}; this.data = data; this.setpreferredsize(new dimension(700, 500));
Read more