Search found 2865 matches

by lotsaram
Sun Aug 20, 2017 9:26 pm
Forum: Cognos TM1
Topic: SubsetElementGetIndex TI function
Replies: 9
Views: 660

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: 15
Views: 4506

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

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

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

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

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

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...
by lotsaram
Thu Aug 10, 2017 6:27 am
Forum: Enhancements
Topic: RFE 82935 Hidden Dimension tab in TM1 Web 10.2.2
Replies: 4
Views: 880

Re: RFE 82935 Hidden Dimension tab in TM1 Web 10.2.2

ykud wrote:
Thu Aug 10, 2017 3:51 am
Looks like this functionality was added in 10.2.2 FP7:
http://www-01.ibm.com/support/docview.w ... wg27049519
+1
by lotsaram
Thu Aug 03, 2017 10:19 pm
Forum: Cognos TM1
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 546

Re: Finding out which Views a Subset belongs to?

HI Lotsaram, possibly a silly question but did you enclose the dimension and subset names in double quotes? I seem to get the following - albeit using Wim's code in a standalone batch file I got it working but interestingly it was the opposite. If I had a batch file findstr /n /r /s /i /m /c:"7,%1!...
by lotsaram
Thu Aug 03, 2017 5:40 pm
Forum: Cognos TM1
Topic: Tracking User Logins
Replies: 17
Views: 1446

Re: Tracking User Logins

I use this pretty much always and it works flawlessly

log4j.appender.USR=org.apache.log4j.SharedMemoryAppender
log4j.appender.USR.File=userlogin.log
log4j.appender.USR.MaxFileSize=5 MB
log4j.appender.USR.TimeZone=Local
log4j.logger.TM1.Login=DEBUG, USR
by lotsaram
Wed Aug 02, 2017 10:50 pm
Forum: Cognos TM1
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 546

Re: Finding out which Views a Subset belongs to?

Works for me if and only if the dimension and subset names contain no spaces. Once the names contain spaces FINDSTR treats the space as an OR operator within the context of the regex regardless whether the /L argument is given. So end up with more false positives then ever since most subsets and mos...
by lotsaram
Wed Aug 02, 2017 7:18 pm
Forum: Cognos TM1
Topic: }PlanningControl What is this system cube? What is it for?
Replies: 2
Views: 152

Re: }PlanningControl What is this system cube? What is it for?

I don't see this cube on any of my systems except for those which have had "TM1 Applications" (Contributor) published at some point (none currently do). I can only assume this is created by Performance Modler. In the ApplicationParameters there are some params that refer to the "TUnit" which is the ...
by lotsaram
Wed Aug 02, 2017 7:00 pm
Forum: Cognos TM1
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 546

Re: Finding out which Views a Subset belongs to?

Wim Gielis wrote:
Wed Aug 02, 2017 4:56 pm
Something like this (pieced together based on the internet)
...
Oh me likey +1
+2 if it all works OOTB when I test it.

Do you really need the 2 blank lines or is that gospel of the interwebs?
by lotsaram
Wed Aug 02, 2017 4:34 pm
Forum: Cognos TM1
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 546

Re: Finding out which Views a Subset belongs to?

If you are old school and like the command prompt, you could try the following from your data folder: findstr /i /s "<subset>" *.vue The main issue I have with this when I've used it is all the false positives if the subset has a common name. Is there a way to search over a line break? ... As the v...
by lotsaram
Wed Aug 02, 2017 2:25 pm
Forum: Cognos TM1
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 546

Re: Finding out which Views a Subset belongs to?

This post got me to thinking about private views. Since as far as I know private objects are ignored at startup and only read into memory when the user logs on then if deleting a public subset will the server throw an error if the subset is only referenced in a private view belonging to a user who d...
by lotsaram
Wed Aug 02, 2017 2:13 pm
Forum: Cognos TM1
Topic: TM1 Admin Server - Adjusting the default MTU of 1460
Replies: 5
Views: 160

Re: TM1 Admin Server - Adjusting the default MTU of 1460

Something like this.... http://www.tm1forum.com/viewtopic.php?t=379 looks like it has been deprecated for a while. Wow the documentation actually refers to "iTM1" LOL Ahh the 90s when iThis and iThat was kinda new and cool and kinda sorta stood for "internet appliance". Way before Apple decided tha...
by lotsaram
Mon Jul 31, 2017 4:19 pm
Forum: Cognos TM1
Topic: Display Sandbox Values within TM1 Perspective
Replies: 4
Views: 156

Re: Display Sandbox Values within TM1 Perspective

Hello Community, can someone tell me how i can display values from Tm1 Cube and values from a Sandbox (Same Datapoint) within the same time in an Perspective Report. ( see attached description ) thanks to all in advanced Chris Short answer. In perspectives you can't. There are no tm1-excel formulas...
by lotsaram
Thu Jul 27, 2017 8:52 am
Forum: Cognos TM1
Topic: SubsetElementGetIndex TI function
Replies: 9
Views: 660

Re: SubsetElementGetIndex TI function

I guess it is not really returning the index of the element in the subset that is useful If the function SubsetElementDelete only takes an index instead of an element name, I would be interested in the index number in the subset. There is a ER for SubsetElementDeleteByName if you want to vote for i...
by lotsaram
Wed Jul 26, 2017 2:51 pm
Forum: General
Topic: Upcoming server migration
Replies: 14
Views: 1162

Re: Upcoming server migration

Email notifications working again :D
by lotsaram
Tue Jul 25, 2017 6:58 am
Forum: Cognos TM1
Topic: Concatenated string with Expand Function
Replies: 16
Views: 1177

SubsetElementInsert with index of 0

I can't believe I only just found this out. This goes straight into the playbook.