TM1 Forum

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...

... 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...

...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...

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 ?

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...

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...

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...

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 ...

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

Thanks for the update. How do u decide that how much time the process should be on Sleep ?
I mean is there a way to find out the completion of the previous thread

MarenC wrote: ↑Tue Aug 11, 2020 7:45 am I experienced something similar and used the Sleep function between each runprocess, which seemed to then populate all the data.

Are you talking about the SLEEP function itself ?

MarenC wrote: ↑Tue Aug 11, 2020 7:45 am I experienced something similar and used the Sleep function between each runprocess, which seemed to then populate all the data.

Many thanks for the update. Can you please let me know how did you achieve that sleep function ?

Thanks
Sree

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 ...

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...

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 ...

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...

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...

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 ...

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...

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...

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...