Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2012-08-07T06:11:28Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic Multifile Cube Processing in Cognos 8.3 Transformer

‏2012-08-06T07:41:15Z |
Hi Gurus,

Currently i am using the version 8.3 for cognos transformer & here i need to build one large cube that is larger than 2GB. For minimizing this, i found like we can use multifile cube processing but i can't able to find the option for it here. I googled & found like need to include "<Preference Name="MultiFileCubeThreshold" Type="int" Value="500000"/>" in the cogtr.xml. As i am new to transformer, i am not sure in which section we need to include this. kindly provide your inputs on this.

Thanks in Advance.

Regards,
Sundar.
Updated on 2012-08-07T06:11:28Z at 2012-08-07T06:11:28Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Multifile Cube Processing in Cognos 8.3 Transformer

    ‏2012-08-06T09:01:47Z  in response to SystemAdmin
    The cogtr.xml file isn't really that fancy. The file should look roughly like:

    
    <?xml version=
    "1.0" encoding=
    "UTF-8"?> <Settings><Sections><Section Name=
    "Transformer"> <Preference Name=
    "height" Value=
    "784"/> ..... <Preference Name=
    "File4" Value=
    "C:\Program Files (x86)\cognos\c8.4.1\webcontent\samples\models\Transformer8\EN\Sales and Marketing.mdl"/> </Section></Sections></Settings>
    


    You can see the list of preferences within the file. You can add your new preference setting by copying and pasting the text that you have found anywhere within the sequence of existing preferences. The easiest thing to do would be to add the new preference just before the closing "Section" tag. This would turn the above sample into something that looks like:

    
    <?xml version=
    "1.0" encoding=
    "UTF-8"?> <Settings><Sections><Section Name=
    "Transformer"> <Preference Name=
    "height" Value=
    "784"/> ..... <Preference Name=
    "File4" Value=
    "C:\Program Files (x86)\cognos\c8.4.1\webcontent\samples\models\Transformer8\EN\Sales and Marketing.mdl"/> <Preference Name=
    "MultiFileCubeThreshold" Type=
    "int" Value=
    "500000"/> </Section></Sections></Settings>
    


    Alternately, you could use any of the other options to set the MultiFileCubeThreshold. For example:
    • SystemAdmin
      SystemAdmin
      15496 Posts
      ACCEPTED ANSWER

      Re: Multifile Cube Processing in Cognos 8.3 Transformer

      ‏2012-08-06T09:14:12Z  in response to SystemAdmin
      Hi Phil,

      Thanks a lot for your quick response.

      I have placed like this in cogtr.xml. But when i googled, i found like 'MultiFileCubeThreshold' needs to be placed above <Section Name="RecentFileList">. Kindly confirm me whether do we need to follow any specific sequence for it.

      <?xml version="1.0" encoding="UTF-8"?>
      <Settings>
      <Section Name="Transformer">
      <Preference Name="PowerPlayPath" Type="string" Value="..\..\cer5\bin\PwrPlay.exe"/>
      <Preference Name="iDate" Value="0"/><Preference Name="iLdate" Value="0"/>
      <Preference Name="sdate" Value="0"/><Preference Name="sShortDate" Value="M/d/yyyy"/>
      <Preference Name="CustColor0" Value="0"/><Preference Name="CustColor1" Value="0"/>
      <Preference Name="CustColor10" Value="0"/><Preference Name="CustColor11" Value="0"/>
      <Preference Name="CustColor12" Value="0"/><Preference Name="CustColor13" Value="0"/>
      <Preference Name="CustColor14" Value="0"/><Preference Name="CustColor15" Value="0"/>
      <Preference Name="CustColor2" Value="0"/><Preference Name="CustColor3" Value="0"/>
      <Preference Name="CustColor4" Value="0"/><Preference Name="CustColor5" Value="0"/>
      <Preference Name="CustColor6" Value="0"/><Preference Name="CustColor7" Value="0"/>
      <Preference Name="CustColor8" Value="0"/><Preference Name="CustColor9" Value="0"/>
      <Preference Name="DataWorkDirectory" Value=" "/>
      <Preference Name="ModelWorkDirectory" Value=" "/>
      <Preference Name="height" Value="724"/>
      <Preference Name="maximize" Value="3"/>
      <Preference Name="width" Value="1022"/>
      <Preference Name="xOffset" Value="1"/>
      <Preference Name="yOffset" Value="0"/>
      <Preference Name="MultiFileCubeThreshold" Type="int" Value="500000"/>
      </Section>

      <Section Name="RecentPackageList">
      <Preference Name="mru_entry_0" Value=""/>
      </Section>
      <Section Name="RecentFileList">
      <Preference Name="File1" Value=""/>
      <Preference Name="File2" Value=""/>
      <Preference Name="File3" Value=""/>
      <Preference Name="File4" Value=""/>
      </Section>
      </Settings>

      Regards,
      Sundar.
      • SystemAdmin
        SystemAdmin
        15496 Posts
        ACCEPTED ANSWER

        Re: Multifile Cube Processing in Cognos 8.3 Transformer

        ‏2012-08-06T12:21:42Z  in response to SystemAdmin
        Sorry, yes, it should be in the "Transformer" section but it doesn't matter where it is in this section.
        • SystemAdmin
          SystemAdmin
          15496 Posts
          ACCEPTED ANSWER

          Re: Multifile Cube Processing in Cognos 8.3 Transformer

          ‏2012-08-07T06:11:28Z  in response to SystemAdmin
          Thanks Phil. Let me try it once.