SEO

We have a SSAS 2005 Cube already created for Sales Executives. As of now, I
can see reports for all of them as an admin. I would like to restrict reports
viewed by a Sharepoint (MOSS 2007) user. Basically I would like to show a
Sales Executive, reports that they are supposed to see. I believe there are
many experts over here who can help me out.

What are the technologies involved? Any links or links to documents that I
can follow to achieve this task will be well appreciated.

Basically all you will need is to set up the access rights correctly in
your sharepoint server, SSAS and SQLServer database server to do that. You
can use the Active Directory windows authentication for that, if not you
can simply set up username/password for access.

If the report needs to be shown in a Sharepoint Portal, you will probably
need to have some webparts installed to host the reports coming out from
SSAS.

On Wed, 29 Aug 2007 09:52:04 -0700, Binoy
<Binoy@discussions.microsoft.com> wrote:

> We have a SSAS 2005 Cube already created for Sales Executives. As of
> now, I
> can see reports for all of them as an admin. I would like to restrict
> reports
> viewed by a Sharepoint (MOSS 2007) user. Basically I would like to show a
> Sales Executive, reports that they are supposed to see. I believe there
> are
> many experts over here who can help me out.
>
> What are the technologies involved? Any links or links to documents that
> I
> can follow to achieve this task will be well appreciated.



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Nestor,

Thank your for a really good insight into these technologies. I need to use
the AD authentication. I found this article
[http://www.sqlserveranalysisservices...rin SSAS.htm]
to limit access on the cube. So I was trying to limit access of a specific
Sales Executive just to his/her own reports.

I will be using Proclarity webpart to show these reports on MOSS 2007.

If I will have any questions during this procedure, I will post them.

Thanks for your help -Binoy

"Nestor" wrote:

> Basically all you will need is to set up the access rights correctly in
> your sharepoint server, SSAS and SQLServer database server to do that. You
> can use the Active Directory windows authentication for that, if not you
> can simply set up username/password for access.
>
> If the report needs to be shown in a Sharepoint Portal, you will probably
> need to have some webparts installed to host the reports coming out from
> SSAS.
>
> On Wed, 29 Aug 2007 09:52:04 -0700, Binoy
> <Binoy@discussions.microsoft.com> wrote:
>
> > We have a SSAS 2005 Cube already created for Sales Executives. As of
> > now, I
> > can see reports for all of them as an admin. I would like to restrict
> > reports
> > viewed by a Sharepoint (MOSS 2007) user. Basically I would like to show a
> > Sales Executive, reports that they are supposed to see. I believe there
> > are
> > many experts over here who can help me out.
> >
> > What are the technologies involved? Any links or links to documents that
> > I
> > can follow to achieve this task will be well appreciated.
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>

there is multiple options regarding what do you mean by "show his own
reports"
if you talk about restricting the cube content (1 report accessible by
multiple persons, but only authorized to see their authorized sales region
only)
we talk about cube and dimension security in SSAS himself.

if you have multiple reports created in proclarity and you want to display
only the list of authorized reports, then you have to apply a security to
the report himself, or through MOSS, you can apply different security for
each page / web site / webpart created.
so if you create 1 report dedicated for 1 sale region and 1 report for the
region 2, then you can apply different security in proclarity or MOSS for
each report or page .

and sure... the 2 levels of security works fine together and I recommend to
apply both of them. SSAS security to insure a data level security and
proclarity / MOSS security to insure a presentation layer security.

because if a user can see anything in your cube, then the user can see
everything using another tool or an proclarity adhoc report... so no
security in the cube can result in no security...


"Binoy" <Binoy@discussions.microsoft.com> wrote in message
news:75FF62E4-59DF-446D-A283-88DFB72212B1@microsoft.com...
> Nestor,
>
> Thank your for a really good insight into these technologies. I need to
> use
> the AD authentication. I found this article
> [http://www.sqlserveranalysisservices...rin SSAS.htm]
> to limit access on the cube. So I was trying to limit access of a specific
> Sales Executive just to his/her own reports.
>
> I will be using Proclarity webpart to show these reports on MOSS 2007.
>
> If I will have any questions during this procedure, I will post them.
>
> Thanks for your help -Binoy
>
> "Nestor" wrote:
>
>> Basically all you will need is to set up the access rights correctly in
>> your sharepoint server, SSAS and SQLServer database server to do that.
>> You
>> can use the Active Directory windows authentication for that, if not you
>> can simply set up username/password for access.
>>
>> If the report needs to be shown in a Sharepoint Portal, you will probably
>> need to have some webparts installed to host the reports coming out from
>> SSAS.
>>
>> On Wed, 29 Aug 2007 09:52:04 -0700, Binoy
>> <Binoy@discussions.microsoft.com> wrote:
>>
>> > We have a SSAS 2005 Cube already created for Sales Executives. As of
>> > now, I
>> > can see reports for all of them as an admin. I would like to restrict
>> > reports
>> > viewed by a Sharepoint (MOSS 2007) user. Basically I would like to show
>> > a
>> > Sales Executive, reports that they are supposed to see. I believe there
>> > are
>> > many experts over here who can help me out.
>> >
>> > What are the technologies involved? Any links or links to documents
>> > that
>> > I
>> > can follow to achieve this task will be well appreciated.
>>
>>
>>
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>>

just see it.