dbTalk Databases Forums  

CONSTRAINED flag error in SSAS 2005 and SSRS 2005 using two Params

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss CONSTRAINED flag error in SSAS 2005 and SSRS 2005 using two Params in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
djharper@gmail.com
 
Posts: n/a

Default CONSTRAINED flag error in SSAS 2005 and SSRS 2005 using two Params - 11-20-2005 , 11:08 AM






HELP!!!

Ok, here is my issue. I have a summary SSRS summary report that I want
linked to a detailed row level report. If I only have one parameter -
say my DimTime parameter, I can successfully pass that value to the
detail report and it works fine.

However..

If I want to pass a value for both my DimTime and DimCompany dimensions
it won't work...I receive the Constrained flag error message. Both
parameters are going to be single valued, hidden parameters.

If I modify the detail report to accept queried values it works fine,
but not when I try to pass two dimensions to the query for processing.

Is there a work around for this??? Or what am I missing?

Thanks in advance


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.