Topic
  • 4 replies
  • Latest Post - ‏2012-08-07T06:11:28Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

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

    Re: Multifile Cube Processing in Cognos 8.3 Transformer

    ‏2012-08-06T09:01:47Z  
    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

    Re: Multifile Cube Processing in Cognos 8.3 Transformer

    ‏2012-08-06T09:14:12Z  
    The cogtr.xml file isn't really that fancy. The file should look roughly like:

    <pre class="jive-pre"> <?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> </pre>

    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:

    <pre class="jive-pre"> <?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> </pre>

    Alternately, you could use any of the other options to set the MultiFileCubeThreshold. For example:
    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

    Re: Multifile Cube Processing in Cognos 8.3 Transformer

    ‏2012-08-06T12:21:42Z  
    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.
    Sorry, yes, it should be in the "Transformer" section but it doesn't matter where it is in this section.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Multifile Cube Processing in Cognos 8.3 Transformer

    ‏2012-08-07T06:11:28Z  
    Sorry, yes, it should be in the "Transformer" section but it doesn't matter where it is in this section.
    Thanks Phil. Let me try it once.