Hi I know from other olap Sytems that you can use measure also as a kind of string value output and that kind I searching for.
If I declare a measure in my flatdatastore as number like int it appair in the measure choice, if I declare a string as measure and really need that one as measure it switch to dimension and I have no measure of that kind.
Something like the one below I need and for that I really need the none numerical values as measure.
I goes more komplex with some more dimension i do plan for it but the example below should be allready show what I really need ;)
Question 1 (Shift) | Question 2 (status) | Guestion 3 (Person in charge)
Year:2008 Department 1| Answer 1: night Shift | Answer 2: done| None | Mister X
Department 2|| Answer 1: morning shift | Answer 2: in process | Mister Y
Department 3|| Answer 1: none | Answer 2: none | Mister Z
Would be very great if you could help me since I need it very much ;)
Something like that just with your pivot grid:
https://www.homeworkhelponline.net/blog/programming/excel-pivot-sub-group
(measure) I want text as measure values.
See it so you work for a food catering service with companys in paris, Berlin, Mardid and so on.
you have the Meals:
Pizza
Burger
Lasagne
Spagetti
Free Choice which every possible text could be
for the 4 passible answers pizza, BUrger, Lasagne , Spagetti you mybe can make still a dimension it makes your pivot grid 4 times bigger since every result space (measure) you wanna show is reprenseted as 1 and the so you have for every day the 4 times more rows then you really need.
For checking if for example paris has enough of pizza this month the ccounts and number are great but if youwant easy use that same data for the hang out
where the dimension the Time is the measure should be the real name like pizza , burger and so on and the other side dimesion is then for example the filtered place paris, then a pivot with counts suck and the one you need is a list with as well text values in the results (measures)
Pentaho for example can something like that, good the id is a number but every measure value has a description you also can set. That way you can show the names instad of a 1 for that measure was taken or an null for that measure value wasn't taken.
What I want:
MO TH WE TH FR SA SU
8 am pizza, pasta, burger - - - -
13 pm - - - - - - -
17 pm - - - - - - -
What I currently get:
8 am pizza 1 0 1 - - - -
pasta 0 1 0 - - - -
burger 0 0 1 - - - -
13 pm pizza
pasta
burger - - - - - - -
17 pm pizza
burger- - - - - - -
First what I want everyone understand the other is good for anlyse like to check ho often had they in the month pizza , pasta and burger but as out fut for the comapany as meal list can you forget that view totally.
Hello,
I'm not certain what you are asking for. Can you please provide some more detail about your question?
Q=Question
Year=Year
D=Department
A=Answer (non numerical measure)
Q1|Q2@3
Year D1 A1|A2|A3
D2 A1|A2|A3
D3 A1|A2|A3