I am not seeing how to do a MDX query against cube and bring into chart.using the GUI it seems to want the data in columns instead of a single row.I included an image of my data as MDX query run in sql server Analysisthe way it comes out is a date is each column and the data is in 1 row of that dataset. (my image actually has 2 rows of data - which would be 2 series lines in my old chart system)do I need to rewrite my querys into a regular sql call that puts the data down into static columns with the date in column and then data in column?