Search found 1548 matches

by Wim Gielis
Fri Nov 17, 2017 10:23 am
Forum: Cognos TM1
Topic: Name of subset using in view
Replies: 4
Views: 417

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: 204

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: 3
Views: 227

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: 242

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: 440

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: 237

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: 242

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: 237

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: 106

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: 128

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.
by Wim Gielis
Tue Nov 07, 2017 3:48 pm
Forum: Cognos TM1
Topic: Empty rows in text file
Replies: 4
Views: 156

Re: Empty rows in text file

Have script produce its output in a different file than the .RUX file, to avoid problems in that file.
by Wim Gielis
Tue Nov 07, 2017 3:14 pm
Forum: Cognos TM1
Topic: Empty rows in text file
Replies: 4
Views: 156

Re: Empty rows in text file

That’s by design and known.

What you can do is use the Prolog tab to ExecuteCommand a script to replace the empty lines with something. Then you are ready on time to read in the file tin the following tabs of the process.
by Wim Gielis
Fri Nov 03, 2017 12:15 pm
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 22
Views: 1859

Re: View Extract with TM1 API

But through Rest API it works fine: https://as-msk-a0134:8000/api/v1/Cubes('}ClientGroups')/Views('mdx_View_last9')/tm1.Execute?$expand=Cube($select=Name;$expand=Dimensions($select=Name)),Axes($expand=Tuples($expand=Members($select=Name;$expand=Element($select=UniqueName)))),Cells with headers cert...
by Wim Gielis
Thu Nov 02, 2017 12:38 am
Forum: Cognos TM1
Topic: static subsets saved disappears
Replies: 6
Views: 260

Re: static subsets saved disappears

Analytics123 wrote:
Wed Nov 01, 2017 5:27 pm
We have static subsets disappearing in few dimension .
Please try to be clear. Your subsets aren’t disappearing it’s the elements within the subsets that disappear.
by Wim Gielis
Thu Nov 02, 2017 12:35 am
Forum: Cognos TM1
Topic: DimensionSecurity Rules not being fired
Replies: 11
Views: 329

Re: DimensionSecurity Rules not being fired

Euh Tom, the OP assigns (the same) rights to all groups on the dimensions that are mentioned. They are not group names but dimension names. Also it’s } instead of {

Which is not to say that I agree with these rules or the way of working.
by Wim Gielis
Tue Oct 31, 2017 7:46 am
Forum: Cognos TM1
Topic: Child Elements are not visible under consolidations
Replies: 14
Views: 359

Re: Child Elements are not visible under consolidations

Can you supply screenshots please ?
Also, the .dim file for the relevant dimension.
by Wim Gielis
Sat Oct 28, 2017 12:22 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 15
Views: 620

Re: Undo after save in Excel 2016 with TM1 add in

I cannot reproduce the problem above anymore.

Excel: Version 1709
TM1: PAL 2.0.3
by Wim Gielis
Fri Oct 27, 2017 6:13 am
Forum: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 3
Views: 227

Re: Questions for Code editor (TI/Rule)

In PAW, the TI editor is / will be improved greatly: coloring, function completion, showing the needed arguments of functions, and so on. Myself, I use Notepad++ with a TM1 language addon. I have an automatic way of copy/paste TI and rules code to a (new) Notepad++ document with the TM1 language act...