0 Replies Latest reply on Mar 28, 2010 10:11 AM by yesmein

    OLAP or Datagrid to present

    yesmein

      Hello,

      I have been struggling with this and would appreciate if anyone can guide me here.

      I am getting a resultset from a database and I need to present it in a particular format. I tried with DataGrid and it doesnt work, I read through OLAP documentation and saw the statement "Flex supports only numeric values for the measure of a cube". I am stuck and not sure how to do this.

       

      The resultset I am getting is of the following format

      <Details>

           <Company>

                <Name> Intel </Name>

                <ID> 2356 </ID>

                <City>Santa Clara </City>

                <State> California </State>

           </Company>

           <Financials>

                <Cash>2345</Cash>

                <Liability>9876</Liability>

                <Assets>457847</Assets>

           </Financials>

           <Profile>

                <Employees>44459</Employees>

                <Industry>computer</Industry>

           </Profile>

           <Year>2009</Year>

           </Company>

           <Company>

                <Name> Intel </Name>

                 <ID> 2356 </ID>

                <City>Santa Clara  </City>

                <State> California </State>

            </Company>

           <Financials>

                 <Cash>4857</Cash>

                 <Liability>8769</Liability>

                 <Assets>36456</Assets>

           </Financials>

            <Profile>

                 <Employees>56489</Employees>

                 <Industry>computer</Industry>

           </Profile>

            <Year>2010</Year>

           </Company>

           <Company>

                <Name> IBM  </Name>

                <ID> 2356 </ID>

                 <City>Santa Clara </City>

                <State>  California </State>

           </Company>

            <Financials>

                <Cash>2345</Cash>

                 <Liability>9876</Liability>

                 <Assets>457847</Assets>

           </Financials>

            <Profile>

                 <Employees>44459</Employees>

                 <Industry>computer</Industry>

           </Profile>

            <Year>2009</Year>

           </Company>

           <Company>

                <Name> IBM </Name>

                 <ID> 2356 </ID>

                <City>Santa Clara  </City>

                <State> California </State>

            </Company>

           <Financials>

                 <Cash>4857</Cash>

                 <Liability>8769</Liability>

                 <Assets>36456</Assets>

           </Financials>

            <Profile>

                 <Employees>56489</Employees>

                 <Industry>computer</Industry>

           </Profile>

            <Year>2010</Year>

           </Company>

      </Details>

       

      The output needs to of the below


      IntelIBM
      2009201020092010
      Financials
        Cash587484564764657846456740
        Liability56475634354585789898798
        Assets354558799034535789787
      Profile
        Employees634536678868766895688
        IndustryComputersComputersComputersComputers
      ID235667678
      CitySanta ClaraSan Jose
      StateCaliforniaCalifornia