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 ;)
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
Hello,
I'm not certain what you are asking for. Can you please provide some more detail about your question?