Search found 1557 matches

by Wim Gielis
Thu Dec 14, 2017 9:57 am
Forum: Cognos TM1
Topic: DimensionSecurity Rules not being fired
Replies: 14
Views: 481

Re: DimensionSecurity Rules not being fired

Thank you tony.wijaya
by Wim Gielis
Thu Dec 14, 2017 8:03 am
Forum: Cognos TM1
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 378

Re: Change in Element Name of a frequently used Dimension

One question i had is after Swapping the Alias with the Initial name, suppose we do not delete the Alias(which will now contain the Initial Element Name). Will this impact the existing Cubes Data/Rules/TI processes/Worksheets in a negative way i.e will they break them ? Or they will work as before ...
by Wim Gielis
Mon Dec 11, 2017 7:06 pm
Forum: Cognos TM1
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 274

Re: carry forward a dimension elements to another dimension

hi, I am adding to dimension A , but I am just appending dimension b to dimension A. But dimension B can change any time and that needs to be reflected on DImension A on daily basis. So I have to unwind Dim B elements in Dim A daily and then readd dim B elements to dim A . so to append Dim B to Dim...
by Wim Gielis
Sun Dec 10, 2017 10:54 pm
Forum: Cognos TM1
Topic: Anyway to prevent Files to Accidentally DBSW ?
Replies: 8
Views: 272

Re: Anyway to prevent Files to Accidentally DBRW ?

Jean, DBRW formulas on their own will not write data to a cube. Not in manual calc mode, not in automatic calc mode. So it has to be the case that you or the user enters a value over a DBRW. Or do you use a DBS function ? A DBRW formula will only show what is currently in the cube, if you do not ent...
by Wim Gielis
Sun Dec 10, 2017 11:36 am
Forum: Cognos TM1
Topic: PAW questions
Replies: 5
Views: 285

Re: PAW questions

And what about the TI function in hierarchies as the variant of Dimsiz ? To count the number of elements in an hierarchy, or do I miss something ?
by Wim Gielis
Sun Dec 10, 2017 12:59 am
Forum: Cognos TM1
Topic: PAW questions
Replies: 5
Views: 285

PAW questions

Hello all, We can create a process in PAW, and the editor shows coloured functions, arguments to functions, and more of that. However, where can I indicate the data source of the process, like a subset or a text file for example ? When a process creates a dimension, it seems that a Refresh of the ob...
by Wim Gielis
Sat Dec 09, 2017 2:32 am
Forum: Cognos TM1
Topic: converting to date for comparing dates
Replies: 3
Views: 224

Re: converting to date for comparing dates

Did you spend a minute in the help on TM1 rules functions ? Long, Scan, Insrt, and so on.
by Wim Gielis
Wed Nov 29, 2017 5:14 pm
Forum: Cognos TM1
Topic: Adjusting font size of action buttons with VBA
Replies: 2
Views: 194

Re: Adjusting font size of action buttons with VBA

Hi there,

I ran accross the very same issue. Sometimes it works when you save, close and open the sheet, but it's not a guarantee.
So I decided to do it manually rather than automated.
by Wim Gielis
Wed Nov 29, 2017 5:12 pm
Forum: Cognos TM1
Topic: Is TM1 dimension index important?
Replies: 4
Views: 387

Re: Is TM1 dimension index important?

One area where the the index order is important, is when you expand a consolidation. Then TM1 will show the immediate children based on the index. One might want to change the index when this is important. For example, Total Year has 12 children as the months. Then you don't want to have a random li...
by Wim Gielis
Fri Nov 17, 2017 10:23 am
Forum: Cognos TM1
Topic: Name of subset using in view
Replies: 4
Views: 536

Re: Name of subset using in view

EP_explorer wrote:
Thu Nov 16, 2017 1:53 pm
Thank you
You're welcome, glad you like it.
by Wim Gielis
Wed Nov 15, 2017 9:50 pm
Forum: Cognos TM1
Topic: Installing 32bit TM1 Perspectives on 64 bit windows 7
Replies: 3
Views: 276

Re: Installing 32bit TM1 Perspectives on 64 bit windows 7

7Zark7 wrote:
Wed Nov 15, 2017 9:42 pm
So simply, will installing 32 bit Perspectives on 64 bit windows environment work?
Sure, no problem at all.
The bitness of Perspectives should match the bitness of Excel.
A 32 bits client on a 64 bits OS is perfectly fine.
by Wim Gielis
Wed Nov 15, 2017 5:39 pm
Forum: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 525

Re: Questions for Code editor (TI/Rule)

Hello

I don't know Atom so I am not in the position to answer this question, unfortunately.
Maybe others have experience with it.
by Wim Gielis
Mon Nov 13, 2017 7:55 pm
Forum: Useful code, tips and tricks
Topic: Inspecting views
Replies: 3
Views: 375

Re: Inspecting views

Thanks guys
by Wim Gielis
Sat Nov 11, 2017 5:26 pm
Forum: Cognos TM1
Topic: DimensionElementDelete deleting alternate elements
Replies: 6
Views: 539

Re: DimensionElementDelete deleting alternate elements

Code: Select all

pDim = 'DimensionNm' ;
x = DimSiz( pDim );
WHILE(x > 0 ) ;
  element = DimNM( pDim ,x) ;
  if ( SUBST(element, 1, 5) @= element1 );
	DimensionElementDelete(pDim, element );
  EndIf;
  x = x - 1;
END;
by Wim Gielis
Fri Nov 10, 2017 1:03 pm
Forum: Cognos TM1
Topic: Installation of TM1 Perspectives: Excel crash
Replies: 3
Views: 322

Re: Installation of TM1 Perspectives: Excel crash

Hello Pandinus, Yes I did, because I entered a user with admin rights to do the installation. Strange thing is, now I am working on the server and Perspectives crashes there as well. Before noon, it still worked. Guess it's Friday :-) For reference, Event viewer information is: Faulting application ...
by Wim Gielis
Fri Nov 10, 2017 12:25 pm
Forum: Useful code, tips and tricks
Topic: Inspecting views
Replies: 3
Views: 375

Inspecting views

Hello all, Almost weekend, so here's a nice one. Attached is a generic process to investigate public and private views (*.vue files) and their usage of public and private subsets (*.sub files). A new control cube is generated, see inside the process for instructions. Let me know all questions or rem...
by Wim Gielis
Fri Nov 10, 2017 12:17 pm
Forum: Cognos TM1
Topic: Installation of TM1 Perspectives: Excel crash
Replies: 3
Views: 322

Installation of TM1 Perspectives: Excel crash

Hello all, I just installed TM1 Architect and Perspectives on a new laptop. Architect works fine, but Excel crashes as soon as I start Perspectives. I don't even see a workbook or sheet. Excel version: 1710 (build 8625.2121 click to run) Planning Analytics: last version 2.0.3 There are no Excel addi...
by Wim Gielis
Fri Nov 10, 2017 7:41 am
Forum: Cognos TM1
Topic: Export Data from Cube View to File
Replies: 4
Views: 181

Re: Export Data from Cube View to File

Hello Rather than asking for a lot of code and copy/paste like a monkey would do, please have a look at the codes in the TM1 model. I bet that the model already contains such codes. Typically look for functions like SubsetCreate, ViewCreate, ViewSubsetAssign, ... in the Prolog tab. In the Data tab y...
by Wim Gielis
Fri Nov 10, 2017 7:33 am
Forum: Cognos TM1
Topic: Cannot insert new element in element attribute dimension
Replies: 7
Views: 204

Re: Cannot insert new element in element attribute dimension

As was said before, You can right-click the dimension in server explorer, select Edit Element Attributes, and then Edit->Create New Attribute or you can use AttrInsert in a TI process.