Filling a cube from the database?

Hi,

For a crosstab report, BIRT takes a database result set and "pivots" that into a cube and then displays that pivoted result.

Is there a way that we could tell BIRT that the cube is populated directly from a database query and to not actually pivot the set?

The reason is we already have this pivoting as common functionality used througout our app and we'd like to take advantage of that in BIRT.

Find more posts tagged with

Comments

Virgil Dodson

Hi Galen, It is typical for a BIRT Cube to be sourced directly from a database query. Even if your data is already grouped in your SQL, you should be able to add that data to a Data Cube and then into a crosstab. Are you having issues with this approach?

I'm also moving this thread into the Designing BIRT Reports forum.