Hi fancyaj, I didn't have time to apply the suggest answer, because the last weeks i was very busy in another things. But I think in this week I'll take a time to explore this solution.

    When I get any progress, I'll report for you. See you later.

Anyone has good sample of xamPivotGrid with MS Sql Server Analysis Service Cube..? As usig http://localhost/olap/msmdpump.dll is not taking care of Security Properly.

    Hi sandip1004, i've already connected the xamPivotGrid with AS using the example above. But i'm upgrading the security level of my webserver to use the msmdpump.dll, because i percepted that any people that type the URL of the server in the Management Studio is allowed to access the AS DataBase.

   In my case, I'll create users on my Domain Web, and i'll check the Authentication level to Windows Auth (not Anonymous), and the people don't will connect on the AS using the Management Studio, only will connect after pass by the security auth on the website that will request the domain user and pswd.

   I think that this security level is right for me, but this is in my case. I don't know if your case is a scenary like mine. I hope that this info can help you, see you.

Thiago Abreu

Hello Sandip,

Can you give us more details about what type of security you are using?

Note that with the bits of the latest service release there is a new feature that allows you to use Basic, Windows or Digest authentication when you make the connection to msmdpump.dll. If that is what you need you can set the right credentials within XAML or in code behind:

<olap:XmlaDataSource.Credentials>

    <olap:XmlaNetworkCredential Domain="domain"

                                Password="password"

                                UserName="username">

    </olap:XmlaNetworkCredential>

</olap:XmlaDataSource.Credentials>

Do not set the Domain property when you are using Digest authentication.

Best regards.

PPilev.