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 Rhinorhino 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: RTwo
  • Order by date
  1. RTwo

    Need to get Prior Sunday's date

    This is a simple select statement which will help you to find the previous Sunday for today's date. sel CASE when day_of_week=7 then calendar_date-6 when day_of_week=6 then calendar_date-5 when day_of_week=5 then calendar_date-4 when day_of_week=4 then calendar_date-3 when day_of_week=3 then...
  2. RTwo

    Front end tools to access MS Analysis Server cubes

    Try building an ASP solution on SQL Server 2K. Its a very cheap way of building an OLAP reporting architecture on SQL Server 2K and you can all the facilities of changing the dimensions, drill down, etc. You can also use the Pivot tables in Excel 2000 as a front end. If price is not an issue...
  3. RTwo

    What is difference between MDDB Database cubes and Reporting Cubes

    Appreciate your response. What I meant by 'reporting cubes' were the cubes created in Cognos and Business Objects. They don't use a MDDB server but still make a ROLAP (Business Objects) or MOLAP (Cognos PowerPlay) cube. I mean they could connect to any relational Database and still form a cube...
  4. RTwo

    What is the difference between database cubes and reporting cubes

    I have a confusion in my mind about MDDB servers. Why do we need a MDDB server like Oracle Express, MS Analysis Server, Hyperion Essbase, et all. I can understand the advatages of basic things like aggregation, pre summarised data, faster access, cube related security features, building and...
  5. RTwo

    What is difference between MDDB Database cubes and Reporting Cubes

    Need some clarity about MDDB servers. Why do we need a MDDB server like Oracle Express, MS Analysis Server, Hyperion Essbase, et all. I can understand the advatages of basic things like aggregation, pre summarised data, faster access, cube related security features, building and storing...
  6. RTwo

    How to store an Excel file in Teradata??

    If I want to store some Excel files in a column for different rows in a table in Teradata, how can I do it.
  7. RTwo

    Problem in Oracle Import

    I am trying to import an Oracle dump. While the table and view definitions get created the data is not copied and the process also stops after some time throwing an error: ORA2218 - Invalid Initial Storage option Value ORA2219 - Invalid Next Storage option value. I have kept the maximum...
  8. RTwo

    What happens to Collect Stats & Metadata while exporting/archiving?

    When we do an archive in a Teradata database, what happens to the Collected Statistics on the objects in the Teradata database. Do they need to be recomputed or are they also exported. (This option is present in Oracle 8i where this is a facility for certain exports and tables). Can we also...

Part and Inventory Search

Back
Top