Data Reader: Columns Representing Different Entities

Jason Ferguson
Jason Ferguson Customer
Second Anniversary First Comment
edited October 2020 in Platform
Hello 

I have a table where the columns represent different entities of a cube.

Is there a way to load a cube through the reader that associates different columns as specific entities?

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
Board Ver: 10.6
------------------------------

Answers

  • Mateo DE LOS RIOS
    Mateo DE LOS RIOS Active Partner
    Second Anniversary First Comment 5 Up Votes
    edited October 2020
    Hello Jason,

    If I remember well, the ASCII Datareader can't do that.
    You may use the SQL Datareader in order to transpose column in row with a manual SQL query.

    Regards

    ------------------------------
    Mateo DE LOS RIOS
    Consultant
    Micropole Group
    France
    ------------------------------
    -------------------------------------------