Forum Discussion

amritp02's avatar
amritp02
New Contributor II
30 days ago

Exporting Account Type

I'm currently trying to export the account dimension members and their properties through a csv file. I can get all the properties necessary, but I can't get the "Account Type" property through the extender rule. 

 I'm currently using Account_Type= Brapi.Finance.Members.GetMemberInfo(si,dimTypeId,stkItem.Name,True,Nothing,MemberDisplay).Member.GetType.FullName , to get the account type in columns but it isn't returning the correct account type of the member and instead returning " OneStream.Shared.Common.Member " in the columns.

2 Replies

  • rhankey's avatar
    rhankey
    Contributor III

    GetType is not AccountType.

    How about

    BRApi.Finance.Account.GetAccountType(si,MemberId).Name

     

  • MikeG's avatar
    MikeG
    Contributor III

    Hi amritp02​, for sharing/exporting dimension member properties I found it easier to do it in a Cube View and created Dynamic UD8 members, set the V# member in the CV to Annotation to display the text.  Then your users can get real-time property views of the metadata and members without giving them access to the Dimension Library: 

    This is the Dynamic Calc formula for Account Type, where Rows are A#Root.Tree, the Dynamic UD8 members are the Columns:

    Hope this helps, easier to go this route then a BR.