6 Replies Latest reply: Mar 4, 2011 4:21 AM by Zuleinie Bt. Zainal Abidin RSS

    Sort A Dimension

      Hi All,

      How would i sort a dimension by myself for instance..

       

      Data : A, B, C, D, E, F,G, H, I, J, K, L

      but i want to sort as i wish :

      J, A, K, E, G, B

      how would i do tat?

       

        • Sort A Dimension

          Hi All, How would i sort a dimension by myself for instance.. Data : A, B, C, D, E, F,G, H, I, J, K, L but i want to sort as i wish : J, A, K, E, G, B how would i sort that in Pivot Table properties.

            • Sort A Dimension
              Johannes Sunden

              I would probably create a new field in the script for the dimension values, using Dual() and giving each value a numerical underlying value and then just sort the dimension Numerically to achieve the custom sorting.

                • Sort A Dimension

                  HI Johannes;

                  can you give me script example on Dual data type sorting

                    • Sort A Dimension

                      You can do this by giving numeric header to all the dimesion inthe script. just as 1. A , 2. K , 3. V.

                      other way is creating new filed in script for all of your dimesion available. and you can then sort them accordinglyy i n front end.

                        • Sort A Dimension

                          HI,

                          i want to sort [TXT30] as [Account Group Name dimension ] dimension. when should i give numeric header to that dimension.

                          and how to do that?

                          my account group dimension consist of

                          eg:

                          cash, account receivable,inventory,prepaid expenses,account payable, expenses payable...etc

                          how to sort them

                          1-inventory

                          2-account receivable

                          3-cash

                          4-expenses payable

                          5-prepaid expenses

                          6-account payable...etc

                           

                           

                          this is my current script :

                          [GLT0]: // G/L account master record transaction figures
                          Load
                          [RRCTY] as [Record Type_RRCTY],
                          [RVERS] as [Version_RVERS],
                          [RYEAR] as [Fiscal Year_RYEAR],
                          [DRCRK] as [Debit/Credit Ind._DRCRK],
                          [RACCT] as KEY,
                          [RBUSA] as [Business Area_RBUSA],
                          [TSL01] as [Transaction currency_TSL01],
                          [TSL02] as [Transaction currency_TSL02],
                          [TSL03] as [Transaction currency_TSL03],
                          [TSL04] as [Transaction currency_TSL04],
                          [TSL05] as [Transaction currency_TSL05],
                          [TSL06] as [Transaction currency_TSL06],
                          [TSL07] as [Transaction currency_TSL07],
                          [TSL08] as [Transaction currency_TSL08],
                          [TSL09] as [Transaction currency_TSL09],
                          [TSL10] as [Transaction currency_TSL10],
                          [TSL11] as [Transaction currency_TSL11],
                          [TSL12] as [Transaction currency_TSL12],
                          [TSL13] as [Transaction currency_TSL13],
                          [TSL14] as [Transaction currency_TSL14],
                          [TSL15] as [Transaction currency_TSL15],
                          [TSL16] as [Transaction currency_TSL16];
                          SQL Select RRCTY RVERS RYEAR DRCRK RACCT TSL01 TSL02 TSL03 TSL04 TSL05 TSL06 TSL07 TSL08 TSL09 TSL10 TSL11 TSL12 TSL13 TSL14 TSL15 TSL16 RBUSA from GLT0
                          WHERE RYEAR = 2011 AND BUKRS = 6700
                          ;
                          //STORE * FROM [GLT0] INTO GLT0.QVD;

                          LEFT JOIN (GLT0)
                          LOAD
                          [SAKNR] as KEY,
                          [TXT20] as [Short Text_TXT20],
                          [TXT50] as [G/L Acct Long Text_TXT50];
                          SQL Select SAKNR TXT50 TXT20 from SKAT
                          where SPRAS ='EN' and KTOPL ='FLDA'
                          ;

                          LEFT JOIN
                          LOAD
                          [KTOKS] AS [G/L Account Group],
                          [SAKNR] as KEY;
                          SQL Select KTOKS SAKNR from SKA1
                          WHERE KTOPL ='FLDA'
                          ;

                          LEFT JOIN
                          LOAD
                          [KTOKS] AS [G/L Account Group],
                          [TXT30] as [Account Group Name];
                          SQL Select KTOKS TXT30 from T077Z
                          WHERE KTOPL ='FLDA' AND SPRAS ='EN'
                          ;

                          store GLT0 into GLT0.qvd;