Hello all,
I’ve got a Deskie report that pulls some data from the CMS through a Macro.
The data is all numerical and it’s outputted as dimensions.
The problem is, I cannot use these dimensions to create a pie chart.
What I need to do is to create a dimension with associated values (free space, occupied space, total space) and a measure with values for each of the sub-dimensions (e.g. 160 for free space, 200 for occcupied space and 320 for total space). I don’t know how to do it though, as I’m not too good with the formulas when creating a variable.
Currently, the dimensions themselves have the numerics as values and I do not want that, futhermore my VBA coding skills are too poor to program in in the way I want it to, so I’m hoping that the variable creator in Deskie can help me overcome this.
Anyone know how to accomplish all or part of that?
Any help will be dearly appreciated.
I use BOXI R3 Desktop Intelligence.
Many thanks,
Nawar
nnoori 
(BOB member since 2009-11-16)
Can you create a new variable, based on the original retrieved data, and just define it as a measure? Measures should be able to aggregate when there is no Dimension to slice by, so is it safe to assume that “SUM” would be the projection you are wanting to use?
digpen 
(BOB member since 2002-08-15)
Yep, I did, but it didn’t make any difference, when I try to turn them into a pie chart, the chart is just one single colour with no projection of the other values, it simply ignores everything else I’ve put.
Probably what I want to do is impossible as I see no way of defining a dimension (‘Space’) and adding sub-values to it (e.g. ‘Free Space, Occupied Space’) and then having separate measures attached to each of these (kinda like Action Name and Number of Actions in the Activity universe).
Shame it’s not like Excel where the application isn’t at all concerned where the data comes from, but just what’s in the cells, which is what I need.
Thanks for the reply,
Nawar
nnoori (BOB member since 2009-11-16)
I think I can visualize the issue. What it sounds like you are missing is a column with the description text, is that correct?
Is your dataset one or two columns?
digpen (BOB member since 2002-08-15)
My dataset is three columns - one for total space, one for free space and one for occupied space. Each column is a dimension. All columns have only one row containing the values for them (e.g. 165.65 for ‘Occupied disk space’).
What probably it should be is to have one dimension called ‘Space’ that has values such as ‘Free Space’, ‘Total Space’ and ‘Occupied Space’ and to have a Measure called ‘Size’ that contains numbers for each value in ‘Space’. Problem is I don’t know how to do that in VBA.
Many thanks,
Nawar
nnoori (BOB member since 2009-11-16)