Re: Pivot Table + OLAP authentication (IIS + impersonate)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bluetooth (szymon_dot_slupik_at_cdn.com.pl)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 10:30:37 +0100

Or just add a calculated measure [username] to the sales cube with the
formula UserName, then drag it to the pivot table.

Best,
Szymon

"Bluetooth" <szymon_dot_slupik@cdn.com.pl> wrote in message
news:%23z$ZHVkEEHA.2460@TK2MSFTNGP10.phx.gbl...
> It is simple, OWC does not see OLAP cubes. It starts seeing them when I
add
> asp.net account to the appropriate security role on the olap server (or
just
> add this account to the olap administrators group).
> Once the asp.net service accounts is added to the olap administrators
group,
> I can issue a query like:
> with member measures.uid as 'UserName' select { measures.uid} on columns
> from [Sales]
>
> And this shows that asp.net service is what authenticates to the olap, not
> the actual user.
>
> Best
> Szymon
>
> "Wei-Dong XU [MSFT]" <v-wdxu@online.microsoft.com> wrote in message
> news:dg84o$iEEHA.3568@cpmsftngxa06.phx.gbl...
> > Hi Bluetooth,
> >
> > "(2) OWC10 Pivot table declaration (ASPX):
> > OWC10.PivotTableClass oPT = new PivotTableClass();
> > oPT.ConnectionString = "Data Source=localhost;Initial Catalog=FoodMart
> > 2000;Provider=MSOLAP.2;Client Cache Size=25";
> > oPT.DataMember = "Sales";"
> >
> > Could you be so kind to let me know how you prove in this scenario the
> asp.net application is using asp.net service account credentials instead
of
> > logon user account credential?
> >
> > Look forward to your reply!
> >
> > Best Regards,
> > Wei-Dong Xu
> > Microsoft Product Support Services
> > Get Secure! - www.microsoft.com/security
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
>
>

Relevant Pages

  • Re: Pivot Table + OLAP authentication (IIS + impersonate)
    ... OWC does not see OLAP cubes. ... add this account to the olap administrators group). ... Once the asp.net service accounts is added to the olap administrators group, ...
    (microsoft.public.office.developer.web.components)
  • RE: Using ADMT to migrate service accounts on workstations
    ... The problem is that service account migration wizard would need every ... you are correct that ADMT does not copy the service ... it is recommended to query the service accounts with ADMT - ...
    (microsoft.public.windows.server.migration)
  • Re: OLAP DTS TASK Will not Run using DTSRun in a Batch File
    ... Account instead of a LocalSystemAccount. ... By the way the iSeries is the ... >>migrated the SQL Server to a new domain. ... All the task execute except for the OLAP Task. ...
    (microsoft.public.sqlserver.dts)
  • Re: ADMT V3 - Service Account Migration
    ... The account name is invalid or does not exist, ... is...ADMT creates the service account on DCx while the server is looking at ... > Please see the following extract from the migration log. ... >>> service accounts and have identified all service accounts that run ...
    (microsoft.public.windows.server.active_directory)
  • Kerberos and Analysis User
    ... In my attempts to have users use Kerberos authentication to access AS, ... I created a new account, like DBUSER and gave this account OLAP ...
    (microsoft.public.sqlserver.olap)