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!

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

Recent content by chael

  1. chael

    Metadata Migration SQL to Oracle

    Yes - it is project duplication. Create a new, empty metadata in Oracle and duplicate your existing metadata. There are some detailed tech notes in the knowledge base that describe how to do this.
  2. chael

    MSTR WEB 8.0.1 - Open New Window

    There is the "Open drill results in a new window" check box in Preferences --> Drill Mode in Web That's not exactly what you are looking for though... Chael
  3. chael

    About this forum - Non-technical

    Entaroadun started the 'other' MicroStrategy forum, the Developer's Forum -- I think it is redundant to have 2. This one seems to have more traffic.
  4. chael

    Any major differences between Microstrategy 7.2 and Microstrategy 8.0

    The web has a completely different architecture. Customization, if you have it, will be rendered useless. Everything is now based off of XML control files and java beans. As for Desktop, Free Form SQL, Logical Tables, OLAP cube integration are big enhancements. Thanks, Chael
  5. chael

    Narrowcast -- how to include Graphical Reports in Excel?

    What about using Report Services as the output of the NCS service?
  6. chael

    No Elements Found, Elements disappeared

    have you tried using the MicroStrategy ODBC Driver for Oracle Wire Protocol? Maybe this would quickly fix your problem. Also, be sure to check the database instance prefix in the Warehouse catalog to be sure that you are sending the right browse elements SQL. Chael
  7. chael

    Select ALL rows from table1, & if exists, associated rows from table2

    If you are on MSTR 8.0 you can freehand the SQL. No need to twist the engine's arm. Chael
  8. chael

    Upgrade 7.5.1 to 7.5.3

    FLB, Any idea when the first 8.0 SP comes out? Chael
  9. chael

    Narrowcast Server: Instant Messenger (need feedback)

    FLB - sounds like a great idea, but I haven't seen much demand for it. As IMs become more a part of businesses I could see a sweet spot for that type of delivery. One good use of IM would be for the internal IT folks to get an update when loads complete. I too am curious to know if there is...
  10. chael

    XSL needed

    so, which XSL did you change? In the XML the node names pretty much guide you as to what you are manipulating: mv - metric value h - header ch - column header ...looks like you pretty much figured that out. So, I guess good job on your hacking! LMK if I can guide you through this any further.
  11. chael

    XSL needed

    what version are you on? I assume you are trying to do something in a document object? Removing the word metrics should be pretty easy - the format for putting attributes and metrics all on one row can be handled via Desktop and how you format the report, no?
  12. chael

    Generating a User List

    There should be a command line manager script for this -- do you have the MicroStrategy Administrator?
  13. chael

    Microstrategy Can intregate with GIS(Geographic Infomation System)

    yes. At least, I think your post was in the form of a question. Several companies have worked extensively to build out mapping solutions based on GIS coordinate data. What, specifically, are you looking to do? Chael
  14. chael

    SELECT * in MSTR?

    [I'm helping JRO on this problem so I'll respond] I think the answer to this question is "wait 'til 8" -- the free form SQL would resolve this in theory -- but unfortunately that is not an adequate answer right now. We know that doing this type of query isn't natural for MicroStrategy, so I...
  15. chael

    Recommended approach for customization?

    Because you are working with 7.5.x you can use a transform bean to capture the 'event' of a report being run in web. Since we are in a sort of whiteboarding forum here, let's think through a couple of these steps: 1. When the report runs, we need to let an external process (a custom .dll) know...

Part and Inventory Search

Back
Top