I have a simple calendar table in FM. to this I have added some extra rows. example ,to_number ('95') as Marker1
,to_number ('100') as Marker2. All 'Data usage' Properties are set to Attribute. This seems to be fine ( test sample in FM returns full date column followed by Marker1 and Marker2 columns).
Date Marker1 Marker2
01/01/2013 95 100
02/01/2013 95 100
etc.
But when I create a crosstab with the date as the columns and the markers as the rows I get the date correctly but the values of the Markers as the row values
What I Get
01/01/2013 02/01/2013
95
100
95
100
What I expected
01/01/2013 02/01/2013
Marker1 95 95
Marker2 100 100
what am I doing wrong
Thanks in advance
Hi Phil,
When you create a crosstab, you are delivering the member captions on the edges as your row and column titles, and you are displaying measure values in the crosstab cells. If this were not the case, you would get column headings of 'Date' in your example rather than seeing the date captions.
Why not deliver your data as a List instead of a crosstab? This is effectively what you are doing when you test in Framework Manager.
Cheers!
MF.
Thanks MF. unfortunatly I require the data in a crosstab so I can build a graph from it. I can generate a list without any problems.
In that case you will need your 95 and 100 values as measures, set to aggregate with a Max behaviour, and you will need Marker 1 and Marker 2 as row values within a Markers column.
Cheers!
MF.
Thanks MF.
I have now done that and all seems to now work.
Recap for others: Data from FM brought to QS as Attribute. Crosstab counldn't be created from attribute type data, so data was changed to 'Maximum' on QS property pane (from automatic) and it all started working. ie changing data back to Aggrigate.