Search found 1472 matches

by declanr
Fri Sep 15, 2017 2:06 pm
Forum: Cognos TM1
Topic: Not Fed issue
Replies: 6
Views: 242

Re: Not Fed issue

Is your next period attribute populated correctly? Try clicking trace feeders to see if the value is being pushed to the next month and then you should see where it fails.

If you provide your full rules sheet/s it should help people to analyse it for you.
by declanr
Mon Sep 11, 2017 6:09 pm
Forum: Cognos TM1
Topic: Workspace - Selector Widget Slider Timing
Replies: 3
Views: 204

Re: Workspace - Selector Widget Slider Timing

Thanks for the confirmation Steve, for the most part I have found everything in PAW pretty intuitive so I assumed when I couldn't see anything in the obvious places it probably wasn't a possibility. It's not something I'd be likely to use anyway (slider play button) but when I see something that sho...
by declanr
Mon Sep 11, 2017 6:05 pm
Forum: Cognos TM1
Topic: TM1RPTROW Repeat Problem
Replies: 19
Views: 360

Re: TM1RPTROW Repeat Problem

Just a quick though, do you have a subset called "TOTAL CONTAS ORÇAMENTÁRIAS" - unlikely as I think the MDX syntax you have would error but you reference a subset name in the same way as an element name in MDX so could possibly cause confusion.
by declanr
Sat Sep 09, 2017 5:39 pm
Forum: Cognos TM1
Topic: Workspace - Selector Widget Slider Timing
Replies: 3
Views: 204

Workspace - Selector Widget Slider Timing

Hi All, I have a question that I imagine will either have an extremely simple answer or be something that isn't an option yet. I have a selector widget set as a slider (periods) on a workspace page with all of my other charts etc set to sync with it; when you press the "play" button it loops through...
by declanr
Sat Sep 09, 2017 5:33 pm
Forum: Cognos Planning and BI
Topic: BI Hierarchy Refresh
Replies: 5
Views: 254

Re: BI Hierarchy Refresh

No worries, if you haven't done it before it can be hard to think of the correct terms to search for in the user guides. A server restart also does the same job and I did a project a little while ago at a company that has a scheduled restart every night just in case anything like that had changed.
by declanr
Thu Sep 07, 2017 6:43 pm
Forum: Cognos Planning and BI
Topic: BI Hierarchy Refresh
Replies: 5
Views: 254

Re: BI Hierarchy Refresh

Haven't seen it happen specifically like this but just to check, have you performed the mdx hierarchy refresh function in TI?
by declanr
Thu Sep 07, 2017 6:39 pm
Forum: Cognos TM1
Topic: Use Active Form but found duplicate Hierachy
Replies: 9
Views: 727

Re: Use Active Form but found duplicate Hierachy

I encounter also to this problem, and also to an TM1RPTROW-Formula, which doesn't resolve the subset in Perspectives, but later in TM1Web it does. My version indeed is 10.2.0 FP3 and my Excel is 2013 (for development clientside) resp. 2010 (on the server). Here the appearence: ActReportNoneOrDuplic...
by declanr
Wed Sep 06, 2017 4:45 pm
Forum: Cognos TM1
Topic: Filter a string cube data in MDX
Replies: 2
Views: 107

Re: Filter a string cube data in MDX

Not entirely true, you can loop through the products dimensions by using the generate MDX statement. So it would be generate on a level 0 product subset then pass that in to your other mdx statement using current member. Not always the most efficient though if the product dimension is large.
by declanr
Fri Sep 01, 2017 6:31 pm
Forum: Cognos TM1
Topic: TM1 Rule - Mixing And Or in a If Statement
Replies: 4
Views: 428

Re: TM1 Rule - Mixing And Or in a If Statement

I think the high level concept you are trying to get to is just fixed by using brackets but I may not understand your question fully.

Code: Select all

['Measure']=N: If ( ( ['Thing'] = 1 % ['Thing'] = 2 ) & ( ['ymabob'] = x ), do stuff, do other stuff );
by declanr
Mon Aug 28, 2017 8:57 pm
Forum: Cognos TM1
Topic: PAW installation help
Replies: 6
Views: 279

Re: PAW installation help

Can't imagine many people/anyone will have tried an install on windows 7 home premium to tell you if it actually works but based on the OS I would guess your PC probably doesn't have a great deal of RAM etc but you appear to have selected all default settings for the VM (8gb RAM, 4 cores, 20gb disk ...
by declanr
Sun Aug 27, 2017 5:29 pm
Forum: Cognos TM1
Topic: Applying 2 rules to one item
Replies: 4
Views: 140

Re: Applying 2 rules to one item

TM1 rules apply in order, so if the first (more specific rule) is higher up in the rule sheet - that is the one that will apply. The second rule will only apply to cells that are not effected by the first rule statement.
by declanr
Sun Aug 27, 2017 1:25 pm
Forum: Cognos TM1
Topic: Applying 2 rules to one item
Replies: 4
Views: 140

Re: Applying 2 rules to one item

Your first rule applies to N level elements only but you have consolidated elements selected in your view (such as all storage locations) that means the cell in question is not N level so the second rule which applies to N and C level takes effect instead. If you change your view so all elements are...
by declanr
Thu Aug 24, 2017 5:16 pm
Forum: Cognos TM1
Topic: Rule consolidation Issue
Replies: 6
Views: 189

Re: Rule consolidation Issue

Your rule is pulling from prior month so you need to alter your feeder to push to the next month. Currently you are feeding the same month.
by declanr
Tue Aug 15, 2017 5:52 am
Forum: Cognos TM1
Topic: Coppy data within a cube
Replies: 3
Views: 300

Re: Coppy data within a cube

Some of your viewsubsetassigns have quotes around the subset variable, remove them and it should work. With quotes it is trying to use the literal string instead of evaluating it to the subset name.
by declanr
Sat Aug 12, 2017 5:13 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheet Charts / Graphs not rendering
Replies: 9
Views: 459

Re: TM1Web Websheet Charts / Graphs not rendering

Haven't had a chance to do a proper test but had a look at a sheet I created for one of the models I am working with at the moment, when Infirst created it they were on an early FP of 10.2.2 (1 or 2) now they are on FP7 and it still works ok. The part I had incorrectly remembered was that you do nee...
by declanr
Thu Aug 10, 2017 9:19 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheet Charts / Graphs not rendering
Replies: 9
Views: 459

Re: TM1Web Websheet Charts / Graphs not rendering

To add to this I have seen a similar thing but in my experience you can get away with some hiding but you need a good but varying number of visible rows. So I have had it work where there is a chart (or charts) a number of hidden rows of data (that the chart is based on) then say 20 visible but empt...
by declanr
Thu Aug 10, 2017 6:11 pm
Forum: Cognos TM1
Topic: Cube Size
Replies: 11
Views: 616

Re: Cube Size

Well the syntax would be: ['Price'] => DB (IF(['Price'] > 0 , 'Destination Cube', ''), !Dim1, !Dim2, !Dim3, 'Price'); But if price is zero it wouldn't trigger a feeder anyway so it doesn't need to be conditional. Also you normally wouldn't feed to or from price as you don't need them to add up and i...
by declanr
Fri Aug 04, 2017 10:50 am
Forum: Cognos TM1
Topic: Active form and read only element
Replies: 9
Views: 228

Re: Active form and read only element

I have used cell security a fair few times without any noticeably terrible performance impacts but that being said I only ever need to put them on planning cubes and I very rarely have "large" planning cubes, as I tend to design away from that as much as possible.
by declanr
Fri Aug 04, 2017 9:10 am
Forum: Cognos TM1
Topic: Active form and read only element
Replies: 9
Views: 228

Re: Active form and read only element

Active forms can have security applied in 2 ways; the first is through standard TM1 security, this one will also apply in cube views. The second less used option is simple excel cell protection; I wouldn't recommend this but if you changed your formula in column A to include something like; if these...
by declanr
Thu Aug 03, 2017 10:00 pm
Forum: Cognos TM1
Topic: Adding element to a dimension at run time in TI
Replies: 7
Views: 259

Re: Adding element to a dimension at run time in TI

Are you sure about that Declan ? If an element exists as C and you try to insert the same element as N, nothing happens. Sorry you are correct about this, a dimensionelementinsert statement is completely ignored if the element already exists. I should have said if you do dimensionelementdelete and ...