The user want to see data on Tableau(Reporting tool),and we are creating the query and provide it to Tableau consultant,so that he can configure it.
So i have created a query and dragged the time infobject char. in column and KPIs in row section.but here my concerns is the data is coming in 01,02,03,04 ...23 this format but the actual requirement is the data should populate in the below format,
Time 02 04 06 08 ......12
Key Val:10 20 30 40.......39
As i can achieve this by creating the structure in the query designer level but structure is not supporting by Tableau tool.
So could you please guide me how can i achieve this without creating structure in query designer.or do i need to write exits for it.
my data flow is,,
I am extracting the data through APD--->Direct update DSO--->Standard DSO--->Cube--->Multi provide--->Query.