SSRS reports - 2 different data sources - 1 cube and 1 flat table using same parameter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » SSRS reports - 2 different data sources - 1...

SSRS reports - 2 different data sources - 1 cube and 1 flat table using same parameter

Rate Topic

Display Mode

Topic Options

Author

Message

brenda.marquiss

Posted Tuesday, February 12, 2013 1:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 6:28 AM
Points: 2, Visits: 2

Is it possible for a flat table to use the same parameter as the cube? I know several flat tables can use the same parameter. I am building a repot containing several maxtrix tables some of which will be sourced from a cube and others just flat tables. They all contain the field that I want used as a parameter. I have tried and failed. Is it because a cube parameter value is different to what you actually see?

Post #1418797

brenda.marquiss

Posted Tuesday, February 12, 2013 6:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 6:28 AM
Points: 2, Visits: 2

I have discovered why I was having problems. The cube parameter I was using was not showing as scientific notation but it actually was. I have managed to use part of another string cube parameter and all is now well. So I have answered my own question and yes you can have SSRS reports using both cube and flat tables.

Post #1418928

« Prev Topic | Next Topic »

Permissions