Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
90
Pivot Grid with strings as Measure
posted

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 ;)

Parents
No Data
Reply
  • 90
    Offline posted

      

    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

Children