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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.