Hi,
I am testing how to model different cubes on hana to explore the information from BusinessObjects Cloud. I face a situation that I have the following format:
Table 1
Col1 Col2
a 1
b 2
If I define col1 as a dimension and Col2 as a measure when I want to graph a combined chart about both just appears in one axis as there is only 1 dimension and 1 measure.
So in order to get that I need the data in the following format:
a b
1 1
So there is any way of achiving this with attribute/analytic views in hana?
Thanks in advanced.
Regards.
Hi Javier,
Were you able to figure this out? What do you mean "I want to graph a combined chart about both"
Maybe some screenshots would be good here.
How would you do this in Excel?
Just think of your data in terms of an Excel table and then create your model based on that.