Search found 95 matches

by manu0521
Wed Nov 25, 2020 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Load time and tm1s log
Replies: 1
Views: 140

Data Load time and tm1s log

Hi , I am loading my sales cube from Datawarehouse to tm1 cube , all calculations are performed on Data warehouse side . I am loading around 5 million rows of data and it takes 6 hours . Is this normal as this will be 1 time load and will be refreshing only 2 months of data daily. Also I see my tm1s...
by manu0521
Tue Nov 24, 2020 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: zerout view
Replies: 3
Views: 218

Re: zerout view

stiill the same error : vDimension='Invoiced Partners'; vSourceSubset=vDimension| ' All N'; vMdx= '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Invoiced Partners] )}, 0)}'; if(SubsetExists(vDimension,vSourceSubset)=0); SubsetCreate(vDimension,vSourceSubset); Else; SubsetDeleteAllElements(vdimension,vSourceSub...
by manu0521
Tue Nov 24, 2020 3:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: zerout view
Replies: 3
Views: 218

zerout view

Hi, I am trying to create a view assign subset and then zero out in prolog for the subset, i am doing the below code vDimension='Invoiced Partners'; vSourceSubset=vDimension| ' All N'; vMdx= '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Invoiced Partners] )}, 0)}'; if(SubsetExists(vDimension,vSourceSubset)=1)...
by manu0521
Thu Nov 19, 2020 9:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sql Failed from TI Process , able to execute with same user on ssms
Replies: 1
Views: 218

Sql Failed from TI Process , able to execute with same user on ssms

Hi , I am having an issue where I have a sql in my ti and it fails . The test connection is sucessfull . Few tables fails, but when tested the same tables in sql server management studio works fine. The error i am getting is 19828 [50] ERROR 2020-11-19 21:38:50.245 TM1.SQLAPI 37000[Microsoft][ODBC S...
by manu0521
Tue Nov 03, 2020 10:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Time period Dimension
Replies: 9
Views: 566

Time period Dimension

Hi , We had this time period dimension as a static dimension and add the year and months once a year. Now I am trying to automate using a TI to build this . For few dimensions we remove the hierarchies to the lowest level and then readd them .Since elements might switch positons. For time ,Am i good...
by manu0521
Thu Oct 22, 2020 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SID in Dimension and fact
Replies: 5
Views: 321

Re: SID in Dimension and fact

So should the sid go as an attribute on te dimension and then while loading fact we look up on that attribute to get the code

or

The fact should join with dimension to get the code in a sql view for load

Which option is best in terms of design .
by manu0521
Thu Oct 22, 2020 2:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SID in Dimension and fact
Replies: 5
Views: 321

SID in Dimension and fact

Hi, We are using a star schema model from dwh to build our tm1 cube . The fact table has sid of dimension tables and the measures. so when i create my dimensions from dimension table where should i add my dimension sid and how i link to them while loading my fact. For example , I have a product dime...
by manu0521
Thu Sep 10, 2020 7:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 cpu memory at 97% and will not open architect
Replies: 1
Views: 224

tm1 cpu memory at 97% and will not open architect

Hi ,

I have a tm1 instance where the computer memory is at 97% , how do i trouble shoot which cube or feeders is causing the perfomance issues.

Thanks,
by manu0521
Thu Aug 20, 2020 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Product Dimension Extract
Replies: 6
Views: 1047

Re: TM1 Product Dimension Extract

Hi Wim , Thanks for the suggestions, One question here so i wanted to check for manly three measures like qty,sales and budget if that material has any instance . so i put my source view with all n for all dimensions with 3 measures on measure dimension and a currency dimension where it has input or...
by manu0521
Thu Aug 20, 2020 1:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Product Dimension Extract
Replies: 6
Views: 1047

Re: TM1 Product Dimension Extract

Can you please give an example , where should this count be done with cell increment.

Thanks,
by manu0521
Thu Aug 20, 2020 1:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Product Dimension Extract
Replies: 6
Views: 1047

Re: TM1 Product Dimension Extract

I can write something like this {FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Product] )}, 0)}, [Test].([Product].CurrentMember, [Posting Measures].[Amount]) > 18 )} I can check something similar like Amount and qty is not equal to zero . This will ensure i get all the products that had a sale or not ...
by manu0521
Thu Aug 20, 2020 12:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Product Dimension Extract
Replies: 6
Views: 1047

TM1 Product Dimension Extract

Hi , We have an important issue thats happening in cognos transformer where it cannot handle more than 65000 categories under a member . We have no problem in tm1 in loading how many ever members . Sowe daily do a extract to cognos seperatley a flat file for products dimensions and seperate flat fil...
by manu0521
Fri Jun 12, 2020 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Usign lookup value logic to calculate royalty
Replies: 1
Views: 934

Usign lookup value logic to calculate royalty

Hi Guys , This is a requirment I have where i get a load file from business like Start Date End Date Royalty % Material1 4/1/2013 3/31/2023 2 Material2 4/1/2015 3/31/2023 3 Material3 4/1/2015 3/31/2018 2 Material3 4/1/2018 3/31/2023 4 so there can be royalty rates defined for materials by time range...
by manu0521
Tue May 26, 2020 1:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 log file delete
Replies: 6
Views: 1266

tm1 log file delete

Hi , I have a vb script that deletes the logs which are older than 3 days, I have 3 instances and the task has 3 steps which deletes the logs from 3 instances . I am having issue where the task goes to running state and not completes. When looked at it there is some tm1event log which it canot delet...
by manu0521
Tue May 19, 2020 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Data Handling Help Needed
Replies: 0
Views: 1057

PAW Data Handling Help Needed

Hi , I have a Pax data entry sheet where i enter details and submit a lease information . This gets loaded in paw and user enters details , the entered details are validated ina ti and dimension is updated with information. There is a second sheet where its reviewed showing the lease information wit...
by manu0521
Tue May 19, 2020 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Macro in PAW
Replies: 2
Views: 727

Re: Macro in PAW

so i have a pax sheet which is uploaded to paw , the first sheet is data entry sheet and has a date format and paw picks it as date and shows a calender picker. One thing to be noted is we are not able to empty the cell when a value is selected in date picker, it has to either default to 1900 This s...
by manu0521
Mon May 18, 2020 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Macro in PAW
Replies: 2
Views: 727

Macro in PAW

Hi , I have a small macro in my pax sheet , which is on change of a selection of a list ,clear a cell value . It worksfine in PAX ,but not in PAW. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$F$3" Then Range("F15:F17").ClearContents End If Is this the behaviour ...
by manu0521
Mon May 11, 2020 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opening pax sheet in paw
Replies: 2
Views: 798

Re: Opening pax sheet in paw

I am not able to debug the reason for the issue , tried different things like unmerging the merged cells etc.. Is this error written in any logs.
by manu0521
Sun May 10, 2020 12:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opening pax sheet in paw
Replies: 2
Views: 798

Opening pax sheet in paw

Hi , I am getting the below error when opening a simple data entry sheet with one action button created in PAX and error happens in PAW. The error is : Failed to open the target workbook.Make sure that the file has not been renamed or deleted. I removed the merged cells in the sheet and there is oth...