BuyLog In
Ticket Q317071
Visible to All Users
Duplicate

We have closed this ticket because another page addresses its subject:

OLAP - Add the capability to load cell text formatting from the OLAP datasource and show it by default

Getting wrong field data types of a selected cube after connecting to Analysis Services 2008

created 14 years ago

Hello,
i have build a OLAP browser based on OLAP demo 2010 v1.9.
Now, if i connect to an AS2008 via
pivotGridControl1.OLAPConnectionString = connectionDesigner.ConnectionString;
pivotGridControl1.BeginUpdate();
pivotGridControl1.RetrieveFields();
pivotGridControl1.EndUpdate();
my XtraPivotGrid will be filled, but field data types are not correct.
For example a money dimension in cube is retrieved as double value.
Thanks for help, regards
Patrick.

Comments (3)
DevExpress Support Team 14 years ago

    Hello Patrick,
    Thank you for your question. The XtraPivotGrid does not allow retrieving cell format if the OleDB data provider is used. It is necessary to use the ADOMD provider, which supports this capability. The ADOMD provider was introduced in the XtraPivotGrid version 10.2 ( OLAP - Add the capability to load cell text formatting from the OLAP datasource and show it by default ). Please refer to the PivotGridAdomdDataSource help topic for additional information.
    Thanks,
    Constant

    PO PO
    Patrick Oczko 14 years ago

      Thank you, now it works.

      DevExpress Support Team 14 years ago

        You are welcome, Patrick
        Thanks,
        Constant

        Sign in to comment on this post

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.