Topic
8 replies Latest Post - ‏2012-06-22T09:52:43Z by SystemAdmin
sh226
sh226
5 Posts
ACCEPTED ANSWER

Pinned topic need help creating new cube from flat file and existing dim.

‏2012-06-15T16:38:48Z |
Hello,
i have following:
1. A flat file contains data for my "MEASURE DIM" and two columns to map date and property with existing Period and Property code dimensions. i understand and can create cube from above three dimensions Not a problem.
2. Now i have same flat file and want to add following additional existing dimensions also when creating a cube. I do not have any column or data available in my flat files to Map these dimension. Please help me to add and map these dimensions to step 1. Thanks so much for your help.
Account dim (General Ledger Account)
PropDivision dim
propLocation Dim
Prop Organization Dim
PropOwner Dim
PropStatus Dim
PropThirdParty dim
PropVehicle Dim
Updated on 2012-06-22T09:52:43Z at 2012-06-22T09:52:43Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    658 Posts
    ACCEPTED ANSWER

    Re: need help creating new cube from flat file and existing dim.

    ‏2012-06-18T11:23:08Z  in response to sh226
    Can you please explain your question with some screenshots if possible. it is a bit confusing to understand your requirement.
    • sh226
      sh226
      5 Posts
      ACCEPTED ANSWER

      Re: need help creating new cube from flat file and existing dim.

      ‏2012-06-18T20:29:25Z  in response to SystemAdmin
      Please see attached file for print screen and explanation. Thanks
      • SystemAdmin
        SystemAdmin
        658 Posts
        ACCEPTED ANSWER

        Re: need help creating new cube from flat file and existing dim.

        ‏2012-06-19T09:04:19Z  in response to sh226
        Sorry but i can't see any attachment here
        • sh226
          sh226
          5 Posts
          ACCEPTED ANSWER

          Re: need help creating new cube from flat file and existing dim.

          ‏2012-06-19T15:00:55Z  in response to SystemAdmin
          I am sorry i thought i have attached it. Please take a look now. Thanks
          • sh226
            sh226
            5 Posts
            ACCEPTED ANSWER

            Re: need help creating new cube from flat file and existing dim.

            ‏2012-06-19T15:16:42Z  in response to sh226
            YAK ..it is not loading my attachments.
            • sh226
              sh226
              5 Posts
              ACCEPTED ANSWER

              Re: need help creating new cube from flat file and existing dim.

              ‏2012-06-19T15:21:31Z  in response to sh226
              Pooja
              Can you please give me your email so i can send you file. Thanks
              • SystemAdmin
                SystemAdmin
                658 Posts
                ACCEPTED ANSWER

                Re: need help creating new cube from flat file and existing dim.

                ‏2012-06-20T07:19:57Z  in response to sh226
                Its pooja_11284@yahoo.co.in
                • SystemAdmin
                  SystemAdmin
                  658 Posts
                  ACCEPTED ANSWER

                  Re: need help creating new cube from flat file and existing dim.

                  ‏2012-06-22T09:52:43Z  in response to SystemAdmin
                  I am not sure about how the data source looks for your budget data loading, looking at the document which you have sent. I can suggest you an alternate way. If i understand correctly you need to import data into your cube from your flat file. Have you worked on processing worksheets? You can use some excel functions like "dbs" to update the data in the cube. The following link has an example of the steps about how to use the processing worksheet. See if this can help you.

                  http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/index.jsp?topic=/com.ibm.swg.im.cognos.tm1_dg_dvlpr.9.4.1.doc/tm1_dg_dvlpr_id5729ImportingDataUsingProcessingWorkshee.html

                  Go through each sublinks to understand its functioning as you need to map your flatfile with the cube or you might need to use a lookup cube to insert values in the cube.

                  I might be wrong in understanding your requirement, but whatever i understood i provided solution for that. Just trying to help you out!!