Re: SSAS reports, Proclarity and MOSS 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:75FF62E4-59DF-446D-A283-88DFB72212B1@xxxxxxxxxxxxxxxx
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.com/OLAPPapers/UsingUserNametoControlDataAccessandDefaultMemberinSSAS.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@xxxxxxxxxxxxxxxxxxxxxxxxx> 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/

.

Relevant Pages

  • Re: Pentester convicted..
    ... and thus politely forcing them take responsibility for the protection of privacy of the data they carry. ... and ignored the first 2 reports. ... A security pro notices a flaw, checks to make sure he is not on crack ... Download FREE whitepaper on how a managed service ...
    (Pen-Test)
  • Some over-classified al Qaeda files left on a train in England.
    ... The two reports were assessments made by the government's Joint ... According to the BBC's security correspondent, Frank Gardner, ... intelligence assessment on al-Qaeda is so sensitive that every ... Police are investigating a "serious" security breach after a civil ...
    (sci.military.naval)
  • RE: The Linksys WRT54G "security problem" doesnt exist
    ... several security lists and Internet news outlets, ... Just because no one else ever reports a problem does not mean it does not ... to my amendments and that he planned a follow-up to clarify. ... I *know* what I saw on the original units, but like I told Maggie, just one ...
    (Bugtraq)
  • In Asia Security Monitor
    ... HOMELAND SECURITY, THAI STYLE; ... government to resort to a new homeland defense tactic: ... The International Herald Tribune reports that government-run schools ... teachers, who are considered high-profile members of the community, ...
    (soc.culture.cambodia)
  • [NT] Multiple Vulnerabilities in SuperScout Web Reports Server
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Contains the usernames and passwords for each user of the reports server. ... an attacker can access any reports available on the ...
    (Securiteam)