Post reply

Access Calculated Members with Excel PTable ?

  • December 8, 2005 at 7:44 am

    #111844

    Hi,

    I created a cube with 4 calculated members via a dll - works fine. Data is ok within cube browser.

    When building report in Excel XP with Pivot Table or with Analysis Services Excel AddIn, I can't have access to these 4 calculated members. I'm using a olap connexion.

    What did I do wrong ?

    Thanks a lot for ur suggestions.

    Vincent

  • December 9, 2005 at 5:37 am

    #608627

    Hello Vincent.

    When you say "Data is ok within cube browser" it means that you can see through Browse Data (in Analysis Manager) these 4 calculated members and its respective values while querying the cube?

    Check if there is any kind of sintax error while building these calculated members. PivotTable don't show them if there is any sintax error.

    Let us know.

    Hope this help.


    Fernando Ponte
    factdata.com.br

  • December 9, 2005 at 7:04 am

    #608640

    Yes, 4 calculated members appears ok while browsing data in Analysis Manager. Calcul is ok. Note  : I make this calculation with an external dll coded in VB.

  • December 9, 2005 at 11:11 am

    #608780

    Hello.

    I don't know if Excel XP uses "AddCalculatedMembers" while querying the cube.

    Try to build a report in excel and save as web page adding interactivity (to use Office Web Components).

    Check the results to see if calculated members are present.

    These calculated members are Measures or Dimension members?

    Regards.


    Fernando Ponte
    factdata.com.br

  • December 12, 2005 at 2:49 am

    #608952

    Thanks for your answer. They are Measures members.

    I'll try to build web page as suggested.

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply