Search found 2880 matches

by lotsaram
Fri Sep 22, 2017 1:53 pm
Forum: Cognos TM1
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 15
Views: 271

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi qml/Wim, thank you for your suggestion. we are using ViewExtractSkipRuleValuesSet( pCube, cTempViewFrom, 0 ); in prolog ,but still data is not copied to some of the cells in target version. attached my TI Process code. Regards, Rajesh Dayaneni This is a mash up of a bedrock copy process. Why not...
by lotsaram
Thu Sep 21, 2017 6:22 pm
Forum: Cognos TM1
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 15
Views: 271

Re: Rules Created by Links are not allowing us to copy data from source version to target version

we are using these functions in Prolog ViewExtractSkipCalcsSet( pCube, cTempViewTo, 0 ); ViewExtractSkipRuleValuesSet( pCube, cTempViewTo, 0 ); ViewExtractSkipZeroesSet( pCube, cTempViewTo, 0 ); My oh my. And how many dimensions does the cube have? And how long does the process take?
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: 315

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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