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 Chriss Miller 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: *

  • Users: chael
  • Order by date
  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...
  16. chael

    Recommended approach for customization?

    What avout using Narrowcaster for this?
  17. chael

    Force Join on Count from Lookup Table

    My initial guess is that you can use HOUSEHOLD_ID as a relationship filter, and simply put the counts onto the report...and outer join the two metrics. What does the current report SQL look like?
  18. chael

    Recursive Hierarchy

    Yah, recursive hierarchies are not natively supported by MicroStrategy. The recommendation for these types of schemas is to explode the schema from recursive to dimensional splitting the data into several tables, one for each level in the hierarchy.
  19. chael

    Hard code SQL into Microstrategy

    not yet at least...I believe this is coming.
  20. chael

    Proxies and Reverse Proxies in MSTR

    I'm looking for some feedback / experiences using MicroStrategy behind Proxy servers and corporate firewalls. If anyone has had experiences (good, bad, non-events) I'd appreciate hearing about them. Thanks

Part and Inventory Search

Back
Top