Search found 2878 matches

by lotsaram
Sat Sep 16, 2017 8:38 pm
Forum: Cognos TM1
Topic: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect
Replies: 8
Views: 309

Re: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect

I went through the post and reached the documentation. Thank you for that. Are you saying the only way to create this type of hierarchy is to do it through code on the Advanced tab? In other words, TM1 Architect cannot naturally handle it by, for example, method of importing/loading data and throug...
by lotsaram
Sat Sep 16, 2017 8:59 am
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 235

Re: Creating Cube Generates "Cell type is string" error

Let's give Alan a break from replying to you or I fear he may blow a gasket. First let's go back to square 1. In TM1 all dimensions are equal. There is no special treatment for time or measure dimensions. In the cube properties you can assign a dimension as the measure dimension. But this is just fo...
by lotsaram
Thu Sep 14, 2017 7:17 pm
Forum: Cognos TM1
Topic: TM1 License Question
Replies: 3
Views: 171

Re: TM1 License Question

As far as I am aware the web tier has never contributed to PVU.

(Except for the kinda restriction of Express licensing which is limited to single box install formerly of max 32 cores then changed to max 1600 PVU).
by lotsaram
Wed Sep 13, 2017 11:35 am
Forum: Cognos TM1
Topic: TI Process Doubling Elements?
Replies: 4
Views: 172

Re: TI Process Doubling Elements?

You might want to check the order of your parameters in your DIMIX. Lovey's not going to be too happy. 2nd that. Your DIMIX as written will return 0 100% of the time. You can't have an element in a single consolidation more than once, do you mean that the extant elements exist in their original loc...
by lotsaram
Wed Sep 06, 2017 9:38 am
Forum: Cognos TM1
Topic: Rule
Replies: 3
Views: 154

Re: Rule

Check your syntax on this rule. The proper syntax when using DB to reference a cube is: DB('Name of Cube', Dim1, Dim2, Dim3....Dimx) Yes. Although it would be a pretty decent enhancement if you could use a blank string as the first argument in a DB() to mean "Me. The cube that I'm in" the same way ...
by lotsaram
Wed Sep 06, 2017 7:26 am
Forum: Cognos TM1
Topic: Seeking idea for users management in multiple instances
Replies: 2
Views: 119

Re: Seeking idea for users management in multiple instances

You are talking about a business application designed to manage users and security across multiple TM1 instances. You can build your own application for this, and many larger TM1 shops certainly have. However if you want a OOTB solution to just drop in then commercial products typically have a price...
by lotsaram
Fri Sep 01, 2017 4:09 pm
Forum: Cognos TM1
Topic: Tm1 public subsets gets cleared
Replies: 5
Views: 237

Re: Tm1 public subsets gets cleared

If subsets are "getting cleared" then it's because elements are being deleted and added back to the dimension. To avoid this unwind the dimension rather than deleting elements. There are plenty of topics you can find on unwinding dimensions.
by lotsaram
Fri Sep 01, 2017 6:22 am
Forum: Cognos TM1
Topic: How to get an automatic cubeview refresh with TI Process
Replies: 5
Views: 135

Re: How to get an automatic cubeview refresh with TI Process

The CLIENT is independent of the SERVER. Client requests data, server responds and sends data, client renders data for viewing. And that is how it stays until the client makes another request. Any "automatic refresh" needs to be triggered from the client side. What you want is achievable in Excel (w...
by lotsaram
Thu Aug 31, 2017 12:18 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 286

Re: ASCIIOUTPUT to csv to show data in different columns

Well you are stuck my friend as TM1 only provides the local variables DatasourceASCIIDelimiter & DatasourceASCIIQuoteCharacter which apply to BOTH the text file being read AND the text file(s) being exported. You would think it would be sensible to have separate variables but fact is we don't. So t...
by lotsaram
Wed Aug 30, 2017 4:41 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 286

Re: ASCIIOUTPUT to csv to show data in different columns

Correct, either you use Expand like Lotsaram shows you, either you use the concatenation operator ( | ) to string the data together. Make sure that your numeric values are exported correctly too, if applicable. That's actually a hidden benefit of Expand ;) all variables are treated as string even t...
by lotsaram
Wed Aug 30, 2017 1:30 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 286

Re: ASCIIOUTPUT to csv to show data in different columns

That's correct Wim. Is there a way to change the delimiter for export? Well you are stuck my friend as TM1 only provides the local variables DatasourceASCIIDelimiter & DatasourceASCIIQuoteCharacter which apply to BOTH the text file being read AND the text file(s) being exported. You would think it ...
by lotsaram
Mon Aug 28, 2017 4:25 pm
Forum: Cognos TM1
Topic: Export Dimension along with attribute data into excel
Replies: 5
Views: 217

Re: Export Dimension along with attribute data into excel

Thank You for the responses. But actually my requirement was to write a TI process to take backup of dimension structure along with attribute values which can be executed before updating the dimension so that the original structure can be restored if any issue happens with updation process. In whic...
by lotsaram
Thu Aug 24, 2017 8:13 am
Forum: Cognos TM1
Topic: Export Dimension along with attribute data into excel
Replies: 5
Views: 217

Re: Export Dimension along with attribute data into excel

If you want a human readable form of viewing dimension structure (like subset editor) then you should look at the TM1 Tools add-in. It has a nice feature for exporting dimension structure to Excel and using standard Excel features like grouping to expand and collapse rows.
by lotsaram
Sun Aug 20, 2017 9:26 pm
Forum: Cognos TM1
Topic: SubsetElementGetIndex TI function
Replies: 9
Views: 739

Re: SubsetElementGetIndex TI function

There's also an ER for SubsetAliasGet while you're at it!
http://www.ibm.com/developerworks/rfe/e ... _ID=109262
by lotsaram
Fri Aug 18, 2017 9:53 am
Forum: Cognos TM1
Topic: TM1WEB 10.2.2 URL API
Replies: 16
Views: 4698

Re: TM1WEB 10.2.2 URL API

In case someone stumbles upon this issue, there is a Request for Enhancement (RFE) for exactly this lack of drill option. You can upvote it here: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=73579 There is an APAR relating to this problem, and it's stated to be corrected in...
by lotsaram
Tue Aug 15, 2017 6:26 am
Forum: Cognos TM1
Topic: subset creation moved to epilog and worked
Replies: 5
Views: 408

Re: subset creation moved to epilog and worked

Wim Gielis wrote:
Mon Aug 14, 2017 7:06 pm
ITEMREJECT in the Prolog tab is not the correct function here for you, I guess, given that it's the Prolog tab ?
ItemReject on the Prolog is quite fine. It is just that as Prolog has no data source and executes only 1x that the ItemReject will skip the rest of the Prolog code from that point.
by lotsaram
Mon Aug 14, 2017 6:20 am
Forum: Cognos TM1
Topic: Fresher..Rules & Feeders
Replies: 9
Views: 777

Re: Fresher..Rules & Feeders

Nope. I tried, its pass a consolidated value..... Which incorrect. .... Not "nope". If you want help you post your code. And if you are serious about getting help you post your code AND you post a screenshot of subset editor the 2 missing dimensions showing what the top consolidation is called. Rig...
by lotsaram
Thu Aug 10, 2017 7:42 pm
Forum: Cognos TM1
Topic: Cube Size
Replies: 11
Views: 617

Re: Cube Size

Hi guys, I am trying to use conditional feeders and I've already try to find somehting at internet and I found some examples but I am still not understanding how to do this. I have a dimension with 10 companies, but only 2 of them have prices. And this prices I have to fed another cube and I would ...
by lotsaram
Thu Aug 10, 2017 6:58 am
Forum: Cognos TM1
Topic: Cube Size
Replies: 11
Views: 617

Re: Cube Size

Cube performance may not always be to do with Feeders and as Jim suggests, context is useful. Without context I'd advise you reduce the number of dimensions to improve performance The OP states they have 9 dimensions which let's face it isn't very many. I wouldn't jump to any conclusion that reduci...
by lotsaram
Thu Aug 10, 2017 6:49 am
Forum: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 886

Re: Is there a free way to move data from cube to Tableau?

If you want to avoid scripts in Turbo Integrator (even though it's not very hard) you can also right-click a dimension and choose to export to a flat file. This functionality exists out of the box. Thanks a lot. I have already read "Bedrock.Dim.Export" and tried to write dimension info to flat file...