This discussion is archived
4 Replies Latest reply: Dec 11, 2012 9:49 PM by GlennS_3 RSS

Export file with member alias

Journeyer Journeyer
Currently Being Moderated
Hi,

I am exporting the data via DataExport command. I need the export file to contain the alias
of the members from all dimensions along with the exported data.
Currently the file contains the members names.

Is it possible what I need?

Thanks,
CM
  • 1. Re: Export file with member alias
    KosuruS Journeyer
    Currently Being Moderated
    CM,

    I don't think you can export aliases using a Dataexport command. You can consider following as an alternative:

    1. Export the Alias table using the following:
    query database 'Sample'.'Basic' list alias_names in alias_table 'default';

    2. Write a report script that outputs all the members (either all or level zero). With a report script you can use OUTALTNAMES to output alias names and OUTALTSELECT to specify which alias table you want to use.

    Hope it helps...

    KosuruS
  • 2. Re: Export file with member alias
    GlennS_3 Oracle ACE Director
    Currently Being Moderated
    KosuruS is correct, you can't export alias names using data export and he gave you an alternative. two other ways to achieve this
    1. Use report scripts to create your export
    2. Instead of Dataexport use the CDF (Java custom defined function) JExport. It is available many place and allows exporting Aliases
  • 3. Re: Export file with member alias
    i_need_a_FIX Journeyer
    Currently Being Moderated
    Hi Glenn,

    How to export Aliases using JExport ? I checked the function parameters and do not see where we can specify an alias table.

    Thanks,
    JM
  • 4. Re: Export file with member alias
    GlennS_3 Oracle ACE Director
    Currently Being Moderated
    in Jexport, you specify a list of member names you want to export, for example in their sample calc script
    you see ,@List(@NAME(@currmbr(Market)),@NAME(@currmbr(Product)),@NAME(@currmbr(measures)),@NAME(@currmbr(year)))
    you can change the @name to @alias like
    ,@List(@Alias(@currmbr(Market)),@Alias(@currmbr(Product)),@Alias(@currmbr(measures)),@Alias(@currmbr(year)))

    Of course you could also mix member names and aliases

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points