Tag Info

Hot answers tagged

6

Well...my solution is as follows: I used a dynamic pivot table in a stored procedure. The stored procedure called a View that I created which denormalizes the data. I think used MS Query to hook the stored procedure up to Excel 2010. This loads it up into a nicely formatted table that allows the end user to sort and filter to their heart's content. With ...


5

EAV is a nightmare for BI tools. I've found a few places that build automated processes that generate a "pivoted" view of the EAV table, as an ETL process daily which drops & recreates the table, with columns for each key. However, depending on how your BI tool works, you will still have to manually add the new attributes that are created by the ...


2

You need a date dimension table, and it should look something like this: create table calendar ( date_id int primary key, name text not null unique, date_iso date unique, year smallint, quarter_of_year smallint, month_of_year smallint, day_of_year smallint, day_of_month smallint, fiscal_year smallint, quarter_of_fiscal_year smallint, ...


2

The differences between Cognos and Modeler are very large. Cognos is mainly a summary and reporting tool. It does not do any statistical analysis to speak of (except when you use the part of SPSS Statistics that is optionally integrated into one of the Studios). Modeler is a full data mining tool with many modeling capabilities. Modeler can read and ...



Only top voted, non community-wiki answers of a minimum length are eligible