Search found 47 matches
- Thu Jan 05, 2023 2:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
I wanted to ask a general question. Does the Dimension re-ordering in the cube help in anyway for a faster cube data retrieval in TI ? Or it just reduces memory footprint ? lotsaram , ascheevel ,gtonkin , burnstripe ? Yes. Did you see OptimusPy ? This tool is trying to find the optimal balance betw...
- Thu Jan 05, 2023 11:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
... Hi, Thanks a lot for your inputs. Would this export and import really work ? I have seen that exporting to an Ascii takes more time compared to direct update in cubes as it need to access some shared drive path to create/update the file right. As per our data flow this source view need to be cr...
- Thu Jan 05, 2023 10:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
...use ViewConstruct on the prolog of the TI. I believe ViewConstruct will be limited by the MaximumViewSize config parameter. If the value isn't big enough for the view you're trying to construct, the TI will abort. It's a dynamic parameter so can be adjusted without restarting the service. Thanks...
- Thu Jan 05, 2023 10:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
I wanted to ask a general question.
Does the Dimension re-ordering in the cube help in anyway for a faster cube data retrieval in TI ? Or it just reduces memory footprint ?
lotsaram , ascheevel ,gtonkin , burnstripe ?
Does the Dimension re-ordering in the cube help in anyway for a faster cube data retrieval in TI ? Or it just reduces memory footprint ?
lotsaram , ascheevel ,gtonkin , burnstripe ?
- Thu Jan 05, 2023 10:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
Are you sure it's just the view calculation that's slow, the other option is the data input into target reporting cube is slow or a combination. To isolate you could hash out the contents of the data/meta data tabs and put something like keep some syntax in the data tab like x=1; so the data tab is...
- Thu Jan 05, 2023 10:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
I found that using TI to copy intra-cube or inter-cube can be very slow in certain cases using a CellPutN/CellIncrementN. In one case it was taking almost 4 hours to create snapshots across a few cubes with Sales being particularly slow due to granularity and rules. Changing the process to export t...
- Thu Jan 05, 2023 10:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Re: Data Source cube view optimization in TI
Well first you can make sure that your instance is using MTQ, e.g. MTQ= -1 ot MTQ = All to use all cores, MTQ = -2 to use all cores except 1 or MTQ = 16 to use just 16 cores (assuming the server has more). In all my experience even on big servers and big data models there hasn't ever been a perform...
- Wed Jan 04, 2023 1:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Source cube view optimization in TI
- Replies: 15
- Views: 1648
Data Source cube view optimization in TI
Hi team, We have a calculation cube in our model which has 16 dimensions and its heavily rule driven. Data transfer happens from this calculation cube to reporting cubes whenever user performs some updates from the front end Web. There is a TI which does this data transfer. It creates the calc cube ...
- Tue Aug 11, 2020 5:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess within RunProcess and Data commit
- Replies: 6
- Views: 2730
Re: RunProcess within RunProcess and Data commit
Thanks for the update. How do u decide that how much time the process should be on Sleep ?MarenC wrote: ↑Tue Aug 11, 2020 10:22 am Hi,
Yes the Sleep function itself, see this comment here:
https://tm1forum.com/viewtopic.php?f=3&t=14841#p75262
Maren
I mean is there a way to find out the completion of the previous thread
- Tue Aug 11, 2020 10:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess within RunProcess and Data commit
- Replies: 6
- Views: 2730
- Tue Aug 11, 2020 10:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess within RunProcess and Data commit
- Replies: 6
- Views: 2730
- Mon Aug 10, 2020 7:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess within RunProcess and Data commit
- Replies: 6
- Views: 2730
RunProcess within RunProcess and Data commit
Hi Team, I have the below scenario. I have 3 cubes - A,B,C. Cube A (staging cube) is where the user entered values are stored temporarily and then pushed to cube B (Data storage cube) via a TI (TI No-1). Cube C is a Calculation cube which gets data points from Cube B using a TI (TI No- 2), based on ...
- Fri Jul 06, 2018 11:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Merging of multiple elements
- Replies: 3
- Views: 2960
Re: Merging of multiple elements
Hi, Thanks a lot for the reply. Changing the cube structure or creating a new cube cannot be done in the current structure. I have given dept ID as an example, its just dimension containing an ID field. Also the number of numeric and string measures which are getting captured are more. We have 200 p...
- Wed Jul 04, 2018 1:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Merging of multiple elements
- Replies: 3
- Views: 2960
Merging of multiple elements
Hi All, I have a requirement to merge multiple Dept IDs in to one based on some matching strings and sum the numeric values. I have given a preview of my current data below. (I am also Attaching the screen shot of the file for clarity) Current Dept X Y P Q N1 N2 1 AA XX PQ MN 10 30 2 AA XX RS OP 20 ...
- Tue Apr 17, 2018 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Query on SwapAliasWithPrincipalName
- Replies: 2
- Views: 3082
Query on SwapAliasWithPrincipalName
Hi Team, I have a query on SwapAliasWithPrincipalName. Does this function swaps the names for all elements in the dimensions with the specified alias names ? I have created a dimension subset with selected list of elements only and used this as source in the swap TI. I have put the function in SwapA...
- Thu Feb 22, 2018 1:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic listing of elements using MDX
- Replies: 9
- Views: 5703
Re: Dynamic listing of elements using MDX
Any other changes to be done ? Excel doesn't concatenate strings using the pipe symbol (|). Change your MDX code to not concatenate those strings together. For that matter, I don't understand why you can't make the MDX just one long string anyway??? Sorry thats my bad. I had written a code in TI wi...
- Thu Feb 22, 2018 11:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic listing of elements using MDX
- Replies: 9
- Views: 5703
Re: Dynamic listing of elements using MDX
I have written MDX to create a subset based on the attribute filters. I have tested the same in a TI process using SubsetcreatebyMDX. Sample MDX is given below "{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [Emp] )}, 0)},(' | '[ CubeABC].([Dept].[DeptXYZ],[Measure_CubeABC].[BU]) = 'PQR') ' | ' AND ...
- Wed Feb 21, 2018 5:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic listing of elements using MDX
- Replies: 9
- Views: 5703
Dynamic listing of elements using MDX
Hi All, I have a cube ABC with Emp,Dept,Measure dimensions. My requirement is to dynamically list out Employee Numbers from Emp dimension based on some Emp attribute filter and also based on a specific Dept number in Dept dimension in an Active from. Design is to have Dept number as Drop down in the...
- Mon Jan 12, 2015 11:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Passport Starting error in perspectives with Excel 2013
- Replies: 0
- Views: 1843
Passport Starting error in perspectives with Excel 2013
Hi Team, I am using TM1 9.5.2. Recently I have installed MS Office 2013 in my system. After the installation, I am getting 'Passport Starting error' - tmcamclient message while accessing the server explorer and ISB. Interestingly, before opening perspectives, If I open the TM1 Architect and login, P...
- Tue Aug 05, 2014 5:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to read Japanese characters in TM1
- Replies: 3
- Views: 3149
Re: Unable to read Japanese characters in TM1
What happens when you execute the process and output the string to a text file? You can also have a look at the following TI command: SetInputCharacterSet http://pic.dhe.ibm.com/infocenter/ctm1/v9r5m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.tm1_ref.9.5.2.doc%2Ftm1_ref_id13841tifun_setinputcharacte...