none
currency conversion - stuck on BI Wizard RRS feed

  • Question

  • I've setup:

    • Currency dimension, put Type as Currency, key attribute Type is "CurrencyName"
    • Time dimension, set Type as Time, and set my join attribute Type as "Months"
    • Measure group containing the Exchange Rates, set Type as "ExchangeRate"

    When I run the BI Wizard to define Currency Conversion, my exchange rate Measure group shows up, but there is nothing listed for the "Specify the pivot currency" dropdown.  Nothing is populating.

    I've tried resaving and reprocessing the cube... I don't know what else I could be missing???

    Any suggestions greatly appreciated.

    Thanks,

    John

    Thursday, September 22, 2011 12:29 AM

Answers

  • bonehead am I...

    Currency key attribute AttributeHierarchyVisible property was set to False.  Switched it to True and the currency codes populated.  Oy vey!

    • Marked as answer by DimDude Thursday, September 22, 2011 1:16 AM
    Thursday, September 22, 2011 1:16 AM