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 strongm 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. pabloj

    Write Enabled Dimensions

    You can use writeback to write data at leaf or node level and to restructure dimensions by moving branches and nodes. Many tools (including excel, maybe with some macros) allow you to write back at leaf or node value, but I'm not aware of a tool that gives you the ability to restructure a...
  2. pabloj

    Solution for Oracle synonyms

    You can use dblinks in Postgresql, they are supported in a contrib package, which is also available on windows (v 8.0 only). Because in Oracle you are using a synonym to hide a dblink. What follows is an example taken from the docs: SELECT * FROM dblink('dbname=template1', 'select proname...
  3. pabloj

    LDAP Configuration in BO

    Do you have LDAP up and running? Can you tell me which ldap attributes you have populated? I've run into a bug of the config tool caused by missing attributes. Thanks Stick to your guns
  4. pabloj

    LDAP Configuration in BO

    Do you have LDAP auth up and running? Can you tell me which ldap attributes are populated in your server? I went into a bug of the conf tool caused by missing attributes. Stick to your guns
  5. pabloj

    V 6.1 vs V 6.5 - Big Improvement

    Yes, IMHO, if you are in an FC only environment, there is no point in migrating to v6 Stick to your guns
  6. pabloj

    V 6.1 vs V 6.5 - Big Improvement

    Multiple (non synced) queries in web reports. Stick to your guns
  7. pabloj

    Fact Table field Split into separate Calculated fields??

    Do it in the database with a view, much better from a performance point of view. Stick to your guns
  8. pabloj

    OpenLDAP as a linked server

    Hi, did anyone got OpenLDAP (set up as a linked server) to return more than ADsPath? I'm able to put appropriate clauses in where part of the query but not to choose what is returned. Stick to your guns
  9. pabloj

    Can a time dimension be created from an oracle table?

    Yes, my setup is Oracle 9.2.0.4, MsAS with the latest service pack, MsOleDb provider for Oracle. The date column is of type DATE Stick to your guns
  10. pabloj

    Scan for SQL Instances

    Fast and easy ;-) Stick to your guns
  11. pabloj

    Scan for SQL Instances

    Any portscanner should do the trick, check machines that have something listening on port 1433 (standard port). Stick to your guns
  12. pabloj

    oracle on unix versus oracle on windows

    Remember that often Unix means Solaris, HP-UX and AIX, that all run on a kind of hardware (in terms of performance, throughput and reliability) that is simply not avalable for Linux or Windows. Personally I would not attempt a Tb datawarehouse on Intel hardware and would not trust Windows as a...
  13. pabloj

    Photos as a member property

    I've implemented actions as described by MDXer, all images are on a webserver and the action opens a browser window (from excel) with the image and a short description. Stick to your guns
  14. pabloj

    BusObj Add-in For All Users?

    The key you are looking for is: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\BusinessObjects\5.0\BusObj General Preferences\busobj\Options\AddIn Stick to your guns
  15. pabloj

    Where did BOB go?

    If you mean http://www.forumtopics.com/busobj/ it's up and running. Stick to your guns
  16. pabloj

    Copy Cubes from 1 server to another.

    You can copy and paste them in the Analysis Manager or use backup and restore to the remote server. I usually develop cubes on my laptop and copy/restore them to the testing and development server this way. Stick to your guns
  17. pabloj

    Oracle or Sybase which is better ? why ?

    I don't understand ho MySQL can be an option in an enterprise environment, it lacks stored procedures, views, triggers, check constraints (and many other advanced features), right now it is "just" simple and fast. I would suggest to look for PostgreSQL (*nix and Windows platform support coming...
  18. pabloj

    Roles in Analysis Services

    Basically every cube, for which you didn't enable write back, is read only, it's not a matter of roles. Stick to your guns
  19. pabloj

    Can I use SQL Server Accouts in Analysis Services?

    No, use Windows authentication. Stick to your guns
  20. pabloj

    One to Many MDX Puzzle. Help !!

    You wrote: In our Reporting package (Cognos Impromptu) I can achieve this by summing the Average of each Order/Line No combination for a known dimension. Why not do this in AS, I believe you can build a calculated measure or better add it as a new column in the fact table. Stick to your guns

Part and Inventory Search

Back
Top