Skip to main content
Database Administrators

Return to Question

add tag, trim noise, minor typos
Source Link
Erwin Brandstetter
Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620

Existing setup SQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope...I 'd I'd like to believe that some kind of solution is out there.

Thanks!

Existing setup SQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope...I 'd like to believe that some kind of solution is out there.

Thanks!

Existing setup SQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope. I'd like to believe that some kind of solution is out there.

added 7 characters in body
Source Link
user1822
user1822

Existing setup SqlSQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope...I 'd like to believe that some kind of solution is out there.

Thanks!

Existing setup Sql 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope...I 'd like to believe that some kind of solution is out there.

Thanks!

Existing setup SQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope...I 'd like to believe that some kind of solution is out there.

Thanks!

Source Link
IronicMuffin
IronicMuffin
  • 663
  • 5
  • 15

Solutions for reporting off of an EAV structured database?

Existing setup Sql 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).

Is there any hope that we can transform this data into a format that we can report off of? Google has led me to believe there is no hope...I 'd like to believe that some kind of solution is out there.

Thanks!