3 Replies Latest reply on Dec 16, 2013 6:01 AM by John Walk

    Connect Microsoft Cube Data with Excel

    John Walk

      Hi,

       

      I have a problem regarding the relationship of a cube-date and a date within an excel file. Reason is that I want to add external data to a graph which is generated out of the cube data (microsoft analysis service)

       

      The Cube has a hierarchy out of which I am using the month “ISO Month”, displayed in the format e.g. “2013-01”.

      If I create an excel file with the same wording “ISO Month” and the same format e.g. “2013-01” it is not working. I created for each month (in this example January to December 2013) a row.

       

      How can I add the excel data to the graph?

       

      Thanks a lot!

      cube_date.png

      graph.png