TM1 Forum

What I am trying to say, is that it seems not only feeder section controls feeders creation, but also rules some rules statements, for example ConsolidateChildren. If this is true, than it also should be taken into account when optimizing feeders.

Any cube with a rule associated with it must have a feeders file if using persistent feeders. This is necessary so that on session start the server can validate that the feeder file is same or later time stamped than the cube file. If the feeder file is older this will invalidate all feeder files a...

The mere presence of a rule file, even if empty, will cause creation of a .feeders file for the same cube. Interesting. Than what is stored in that file if not feeders info? I am trying to recreate the model without feeders for currency calculations, to see if it will improve performance. Not sure ...

The feeder file will be created for a cube if any cell in that cube is fed. As tomok indicates, if another cube's rules are feeding the cube in question, you will get a feeder file as long as PersistentFeeders=T in the tm1s.cfg file. That is what I thought, but I deleted all other rules files from ...

Hello All, I am experiencing some strange behaviour with one of the feeders. There are persistent feeders enabled in the model. I changed the rules so that there are no feeders in this cube, stopped TM1 service and deleted .feeder file. I expected that there will be no .feeder file created after the...

So, reporting back the results. I deleted all the history to make cube smaller, leaving only current year - around 8Gb. Even after that, deleting 250k (actually closer to 300K) elements took 11.5 hours. I will try to remove all MDX subsets and rerun the deletion to check if it will improve the perfo...

Thanks guys, reread the reference guide, my mistake - should not use MDX parameter in SubsetMDXSet. Anyway I'll leave Pandinus code running overnight, will report tomorrow what it will give. Thanks all for your inputs.

Also, in the code you posted above, you do not loop over a static subset.

I used:
SubsetMDXSet( DimName, SubName, MDX);
AFAIK it does create a static subset. Am i wrong?

1. Correct, this needs to be done only once 2. Cube has sales data on customer and product dimensions. 20 dimensions in total. The purpose is to bring the cube to a more manageable size. 3. Deleted elements are all n-level 4. Yes, there are MDX subsets on the same dimension 5. There are rules and fe...

That is what I am using: #Prolog DimName = 'ZZZZZ'; CubeName = 'YYYYY' CubeSetLogChanges(CubeName, 0); MDX = '{TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[' | DimName | '].[' | Parent_Element | ']},ALL,RECURSIVE)}, 0)}'; SubName = GetProcessName() | '_Source'; IF(SubsetExists(DimName, SubName) = 1); Subs...

Created static subset, but it seems to be even a bit slower. Did anyone try to edit dimension in a separate server and then copy it it back to original server?

Hi, I am trying to improve performance on dimension element delete. I have a fairly large cube (around 60 GB), with one dimension being about 600k elements. I need to delete all the children of one particular consolidation, which are about 250k elements. I have a simple process running on on subset ...

It seems that provided certificates do not work for older combination of TM1 and Controller. We have TM1 9.5.2 and Controller 10.1 IF4, after certificate upgrade TM1 works fine (Architect and Perspective), while FAP publish constantly fails. As IBM states that it breaks FAP using any other certifica...

Thank you for the idea. It is not an ideal solution, but makes a situation much more manageable. Do you know of the way for a user can see what is defined a default member for the dimension from CAFE?

Hi All, We are implementing CAFE interface for our users and came across some difficulty that I am unable to solve. We have some cubes with 20+ dimensions. When having most of the dimensions in context area in crosstab, there is not enough space for all of them. You can drag them to this area but so...

Hi Gabi,
Did you try to upgrade to the latest FP? (FP3 i think). We had a similar problem with feeders in one of the previous versions, which was solved by upgrading to the latest fp.

1. BI application pool is configured, returned back SingleSignonOption. 2. BI getway machine added to trusted sites on TM1 machine. 3. Getway namespace in BI configuration environment is changed to the name of AD namespace - I think this is the one meant by default namespace? It is the same as I wro...

1. tried to uncheck integrated login in client options - no change 2. bi and tm1 should be configured according to manual but obviously something is missing. here are the settings in tm1p.cfg: ServerCamURI = http://biservername:9300/p2pd/servlet/dispatch ClientCAMURI = http://biservername:80/ibmcogn...

Thanks. Changed:
SecurityPackageName=Kerberos
In BI config deleted:
singleSignonOption IdentityMapping
Still no integrated login...

We are testing new versions of TM1 (10.2.2 FP1) and BI (10.2.2) installations. Authentication is through BI gateway (on a separate BI server). TM1 users can successfully login by entering user and password from relevant AD namespace, but integrated login is not working in architect and perspectives....