Search found 18 matches

by rajeshdayaneni
Fri Nov 10, 2017 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Data from Cube View to File
Replies: 4
Views: 3203

Re: Export Data from Cube View to File

Hello Wim Gielis,

Thank you for your valuable suggestion.
by rajeshdayaneni
Fri Nov 10, 2017 6:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Data from Cube View to File
Replies: 4
Views: 3203

Re: Export Data from Cube View to File

Hi ascheevel ,

thank you for your suggestion.

i am new to Tm1 .Could you please provide the code to do this in TI process .It will helps me a lot.



Regards,
Rajesh dayaneni
by rajeshdayaneni
Fri Nov 10, 2017 6:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Data from Cube View to File
Replies: 4
Views: 3203

Export Data from Cube View to File

Hi, I have to export data from TM1 Cube view to File (not all the records).we need to export specific set of records from the Cube View that satisfies the below condition . IF(Upload_date >= Current_Date ) Please help me to achieve this requirement. we are using Performance Modeler Regards, Rajesh
by rajeshdayaneni
Fri Sep 22, 2017 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 8770

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi qml/Wim,

thank you for your suggestion.

we are using
ViewExtractSkipRuleValuesSet( pCube, cTempViewFrom, 0 );

in prolog ,but still data is not copied to some of the cells in target version.
attached my TI Process code.


Regards,
Rajesh Dayaneni
by rajeshdayaneni
Fri Sep 22, 2017 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 8770

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi qml,

cTempViewTo is a target view.can i send the code written in TI Process.



Regards,
Rajesh Dayaneni
by rajeshdayaneni
Fri Sep 22, 2017 9:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 8770

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi Wim,

Thank you for your reply.

i don't think so,because our TI is able to copy data from current version to final version for some of the cells .please see the attachment.Highlighted cell is not transferring data.



Regards,
Rajesh Dayaneni
by rajeshdayaneni
Fri Sep 22, 2017 6:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 8770

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi lotsaram ,

Cube has 7 dimensions and the process took 30 sec to complete.



Regards,
Rajesh Dayaneni
by rajeshdayaneni
Thu Sep 21, 2017 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 8770

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi qml, thank you for your reply. we are using these functions in Prolog ViewExtractSkipCalcsSet( pCube, cTempViewTo, 0 ); ViewExtractSkipRuleValuesSet( pCube, cTempViewTo, 0 ); ViewExtractSkipZeroesSet( pCube, cTempViewTo, 0 ); Regards, Rajesh Dayaneni
by rajeshdayaneni
Thu Sep 21, 2017 12:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 8770

Rules Created by Links are not allowing us to copy data from source version to target version

Hi, We are trying to copy data from source version to target version with in the same cube using TI. For some of the cells data was not copied from source version to target version. Here some of the cells in source version is feed by Link.we are suspecting that rules created by Link is not allowing ...
by rajeshdayaneni
Wed Sep 13, 2017 9:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copying Data from Source Version to Target Version via TI
Replies: 4
Views: 2915

Re: Copying Data from Source Version to Target Version via TI

Hi Steve,

we are using TM1 Performance Modeler and we are using links to transfer data from source cube to target cube.
in target cube we are trying to transfer customer data from source version to target version using TI.
But it is not happening .




Regards,
Rajesh
by rajeshdayaneni
Wed Sep 13, 2017 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copying Data from Source Version to Target Version via TI
Replies: 4
Views: 2915

Copying Data from Source Version to Target Version via TI

Hi, i am trying to transfer Customer data from source version to target version in the same cube using TI. Issue: Data is not transferred to some of the cells. Some Customers for Source Version is feed by links, this data is not transferring to target version.Could you please help me in solving this...
by rajeshdayaneni
Tue Aug 29, 2017 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rollup Issue in Performance Modeler
Replies: 0
Views: 1589

Rollup Issue in Performance Modeler

Hi, we are loading "Regional %" from "LDP" Cube to "LDP Calc" Cube through Link in Performance Modeler."Regional%" data is not rolling up to consolidated level "LDP Calc" Cube.Please see the screen Prints in the attachment.Could you please help me in...
by rajeshdayaneni
Tue Aug 29, 2017 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 6738

Re: Error: Prolog procedure line (0): Unable to open data source

Hello Edward Stuart,

Below file types exists in the folder
"s:\prod\dfv_proforma\data\"

CHO,CMA,CUB,DIM,FEEDERS,File Folder,RUX,PRO,VUE


Regards,
Rajesh
by rajeshdayaneni
Tue Aug 29, 2017 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 6738

Re: Error: Prolog procedure line (0): Unable to open data source

Hello Elessar,

we are using Performance Modeler.


Thank You ,
Rajesh
by rajeshdayaneni
Mon Aug 28, 2017 11:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 6738

Re: Error: Prolog procedure line (0): Unable to open data source

Hello Edward Stuart, Sorry for the late reply.I was out of station. Problem description: We have a TI Process that runs 24 other TI Processes to import data from Excel files into 24 different cubes. We are getting this error message and similar messages for all 24 cubes: " Prolog procedure line...
by rajeshdayaneni
Wed Aug 23, 2017 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 6738

Re: Error: Prolog procedure line (0): Unable to open data source

Hello Edward Stuart,

this .blb file is not available in the specified location.Could you please help me how to create/generate these .blb files.


Thank You,
Rajesh Dayaneni
by rajeshdayaneni
Wed Aug 23, 2017 9:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 6738

Error: Prolog procedure line (0): Unable to open data source

Hi,

we are getting below Error while running TI Process from Performance Modular.Could you please help me in solving this issue.

Error: Prolog procedure line (0): Unable to open data source "s:\preprod\proforma\data\Surcharge_Excel2.blb".



Regards,
Rajesh