Recent content by wolf5370

Hi guys, I have been struggling with a wiered problem (which I think is an undocumented bug in MSTR 7.2!) - but can't get MSTR Support to look at it as 7.2.2 is no longer supported :( (please no 'upgrade to 7.x/8' replies - we are moving towards 8, but have various projects on various versions...

OK, another problem caused here. The final template (i.e. not the filter report) has a hierarchy as the row ([All Merchandise]), and because the row is hard-coded to {stroke/colour} in the Filter Report, the final report is always at {stroke/colour} too - the level chosen in the original...

Sounds interesting guys, I'll give it a go and get back. Thanks, Richard

CMD MGR command: LIST ALL PROPERTIES FOR USERS IN GROUP "everyone" ; All users are in 'everyone', so you get all the users with their properties. Richard

Sorry, should have said this is a 7.2.2 project...Ta Richard

The scenario is: A report template as follows... Attribute (left hand side) [All Merchandise] Metrics (top) [sales] [% sale floor stock] [% warehouse stock] [% On Order Stock] [% Supplier Stock] [% Other Stock] The % metrics are compound metrics based on counts. For example [% sale floor...

You could change the ASP to put the user in Advanced Drill on return of report - this would give the drills across. We have completely changed the interface (hated those DHTML menus) and have a menu bar with buttons to go directly to the options are users require - and only those! This is...

Agree with kpescatore, as you are using Current Date, then use dynamic dates. Current date - 45 days. Simple. It will make for more efficient SQL too as you will get a "DateField = 'ccyy-mm-dd' clause rather than a subquery. I would only use the Applysimple here if youyr date table is not...

Agreed. Original post did not mention Documents.

You use a transformation table to do the transformation - therefore, it can cater for week on week by year etc without having to match up - you do not need to use dynamic dates, you can use your own date tables. For example, we have the same issue - Mothers day does not match up week on week...

That sounds just like what I want - do you happen to know where the setting is? Is it available in 7i (7.2.4) or only in 7.5 (not moving there for many moons yet). Thanks for your help - hope shines once more. PS: Don't worry if you don't know exactly what the setting is - I can query Support...

Ouch - this is kind of like asking "I've installed VB, where do I start?". A good place would be the MSTR COM Web API course. The PDF Files that come with the SDK contain lots of snippets, but probably not for the uninitiated.

Can you outline the structure of these agregate and the ref tables. I assume something like this: Attribute: Month - Table Ref_M Attribute: Day - Table Ref_D Ref_M: A_Month_ID A_Month_Desc Ref_D: A_Day_ID A_Day_Desc A_Month_ID A_Month_Desc (Don't actually need thuis one, but can save join if...

You can use Transformation to transform your "Count" to Metric "Count Previous Year". Then you have the ability to use a compound metric - ("Count"/"Count Previous Year")*100. In column 3. This is assuming you always want Year on Year (E.g: Run for 2003 - you would get 2003, 2002, %Yr 03 to...

Assume your aggregates are at month. How are you filtering on the month for the report? Let me explain: We have a similar scenario, but with weekly data. For stock we only want a snapshot - latest position. If the user runs the report for the last 10 weeks for example, the dynamic dates...