Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wolf5370

    7.2.2 - Drills across a M2M - aghghghghghgh!!!!!!

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

    Can I set the target level in a hierachy for a report qualification?

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

    Can I set the target level in a hierachy for a report qualification?

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

    Generating a User List

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

    Can I set the target level in a hierachy for a report qualification?

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

    Can I set the target level in a hierachy for a report qualification?

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

    Drilling With Web 7.2.2

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

    Last 45 days filter

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

    Drill Problem

    Agreed. Original post did not mention Documents.
  10. wolf5370

    % change from same metric in different year

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

    Totals on Fact(Ending) Metrics...

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

    Begin

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

    Drill Problem

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

    % change from same metric in different year

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

    Metric using Grouping

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

    Totals on Fact(Ending) Metrics...

    Hi all, This is the problem (7.2.2), We collect Stock Daily and have aggrigates at both Week and Day (amongst others). Because we always want to see a snapshot of the stock, we use End Fact dimensionality. Sum([STOCK]) {~, [All Time]} With Dimesionality of Report Level Std Std and All Time...
  17. wolf5370

    Wish List

    MD: I would be happy if we could just know what things were so we can do read only type operations on the MD - this can be really usefull - Project Documentation and CMDMGR does not cover all. Another pain: Folder permissions - we do not use the personal folder solution that come with MSTR, but...
  18. wolf5370

    Wish List

    Me again. One really annoying thing (in 7.2.2 at least). We usually use local templates as they are report specific for the business here. However, we sometimes make use of shared (non-local) templates (Drill to Template etc). The thing that annoys me is that Drill Maps are associated to the...
  19. wolf5370

    Wish List

    1): Better thresholding options (probably available in 7.5 suite, but hey how many have made that leap - or will?). The ability to colour cell backgrounds, highlight whole rows/columns, Allow user to dynamically vary the thresholds at run time. 2): A better print solution from Web. With the MS...
  20. wolf5370

    Mstr 7.2.2 over the web. Bandwidth probs?

    Hi nlim, as far as I'm aware, both Mstr and Aspelle were to make fixes - something to do with Mstr not putting a data size parm in the header of the autoprompt (returning from server to client) and Aspelle thinking no size parm equals no data. We have been busy stripping down the wait/prompt...

Part and Inventory Search

Back
Top