Hi all,
Is it possible to implement besides row level security the option to show different objects for different users ?
Thanks
Yoav
yohab (BOB member since 2003-12-24)
Hi,
What i really mean is:
Is it possible to create a portal page with X Dashboards and that each user that will enter this page will see his dashboard ,via interactive view
of the dashboards by user,not row level security.
Also: i know there is a way to do that by embedding in the excel flags that will correspond to the @bouser variable,is there another way ?
Thanks
Yohab
yohab (BOB member since 2003-12-24)
I’m a bit confused…
First when you say “Dashboard” are you refering to a single Xcelsisus component with multiple analytics? or an actual SAP Dashboard as built with Dashboard Builder?
Then you mention “portal Page”… is that Infoview? or are you embeding your dashboard into your own webportal elsewhere on your network?
You first need to determine how you would expect your dashboard to know who the current user is? Is it via a Login box somewhere, via BOBJ security (aka BOUser) or some other method.
Then define what exactly you mean by ‘dashboard’ (that term is so overused and can mean many different things). If you have say 8 different Xcelsius Documents (1 thru 8 ) and you want UserA to see 1 thru 4 and UserB to see 5 thru 8 instead… then I THINK the answer is no… dashboard builder might be able to handle object security but what you really want is object REPLACEMENT.
You’d have to build into your individual Xcelsisus Document both ‘sets’ of analytics… one for UserA and one for UserB and then a Show/Hide based upon some value. That value could be a result from a 2nd query which then checks the user’s ID vs a 3rd party security table, or via BOUser itself. (Though I don’t know if you can get BOUser’s Group ID).
Does that help?
JPetlev (BOB member since 2006-11-01)
Hi JPetlev,
Thanks for your reply.
When i say “Dashboard” I mean an Xcelsius chart or gauge that will be
disributed to a webportal using the swf url.
I am familiared with the method of “Dynamic Visibility” in xcelsius with the bouser variable passing through the query and then using it as a dynamic reference for the chart or gauge view.
What I am trying to understand is there a better/recommended way
How to manipulate the visibility of multiple charts/gauges in a single swf.url Without using the logic of flags in the excel spreadsheet.
Is there a way to control it “out side” of the excel to
get a better and safer way of Restricting user’s views on that single swf page which is embedded in the web portal?
Thanks
yohab (BOB member since 2003-12-24)
I think you might be confusing a few things on how Xcelsius works.
The “Excel” portion is only used at Design time. Once you export to SWF there is no Excel within the Xcelsius object. It’s all compiled SWF (or powerpoint/pdf etc…).
That being said… it sounds like you are saying you don’t want to use BOUser, or wondering if there is a better way.
There are LOTS of ways… it just depends on your portal itself however.
In order to tell the Xcelsius to switch views, or display something else you first need to figure out HOW to tell Xcelius when to switch. Using flags in the “excel” is the only method to do this. However the method to populate those flags can be either via BOUser, a database call to some 3rd Party table, or something within your BOBJXI via QAAWS. (I think the newest version of Xcelsius might also be able to hook directly into LiveOffice as well but not positive).
If that doesn’t answer you question, give us a bit more detail on what you’re trying to acomplish. For example… are you saying UserA should see a particular graph, but UserB should see another? Or something more along the lines of Mondays = Graph1, Tuesday = Graph2 etc…
Also when you say ‘outside’ of Excel… what do you have in mind? Is there some system you are already thinking of?
JPetlev (BOB member since 2006-11-01)
Conclusion:
i can’t manage in a simple way interactive view for hundreds of users
when the requirements are that each group will see different view,for example:
i have a swf which presents 5 chart and gagues,i need that each group will see different views:one group see just 2 charts,one group see all components and ctr.
To do that i will need an enormous user mapping inside the excel.
the only solution for that ,that i know about is to use the web-portal security abilities in order to establish such security view option.
or to enable some kind of interaction between the web-portal pages to a
user & group table.
Yoav
yohab (BOB member since 2003-12-24)
I know you’ve reached your conclusion, but just in case you aren’t familar with some of BOBJ’s abilities, I think you might be able to do what you want, but it all depends on a few of your requirements which haven’t been stated.
How many users?
How many Groups?
How many possible Dashboard views?
Is your WebPortal using BOBJ security (ie is it displayed inside Infoview) or is it an SWF file displayed on a non-BOBJ webpage?
If it’s external to BOBJ, then you are correct somewhat… you lose all of your security controls. However if you web page has the ability to pass along a security token you MIGHT be able to simplify things slightly by only putting in switches for Groups instead of users (again depends on number of groups you have to maintain). Or you could always simply pass the USER id back to a database somewhere that contains your security groupings and return a simple Show/Hide/Show set of flags.
Another option would actually be to avoid flags in this case however, and instead have your webportal’s webpage itself redirect the user to a specific 2nd webpage based upon thier credentials within your WebPortal.
So that User 1 logs in to your portal, they are identified as being part of Group 1 (again assuming your webportal has some sort of grouping mechanism ether internally or in an external database). Then redirect them to DashboardForGroup1 webpage (which has security on the page to ensure no one can deep link directly to it of course).
User 2 comes in and is identified as another group and goes to a seperate webpage which displays an entirely different Xcelsius dashboard.
The bottom line is to first determine where your security starts and gets identified. Then to determine how many groups you have to manage and whether it’s feasable to manage individual xcelisus documents vs a single document with security built in.
Either way there are LOTs of ways to do what you want to acomplish, the issue at hand is that no one but yourself (compared to the rest of the BOB boards) knows your particular infrastructure setup to know what is the best method, or to be able to provide a recommendation.
Good luck.
JPetlev (BOB member since 2006-11-01)
My web portal is external.
i didn’t specify the web platform since it’s not decided yet ,according to the we portal view abilities to support such case it will be chosen,
it is a general question.
i’ll keep you update when a solution coming from the portal,table or another mechanism will be fitted.
Thanks again
Yoav
yohab (BOB member since 2003-12-24)