Two parameters having same data
Hi i have a parameter name KeyAccount and KeyAccountKeyAccountSection but these two having same data. what i am doing is for KeyAccountKeyAccountSection i am selecting Internal. if i run the report is that effect the report i mean KeyAccountKeyAccountSection
parameter
anyone can explain me
Thanking You,
siva
May 26th, 2011 3:45am
If I am following you correctly then I don't think the paramaters will affect each other, I suppose it depends on how you have referenced them in your SQL code.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 8:01am
k thank you for your information...i have one more issue
just i run the report it shows that query execution failed for dataset 'Top5Distributors' and parser: the end of the input was reached
like this it is showing but dataset query is executing fine i dont understand y it is showing again like this
this is the query
SELECT
-- NON EMPTY
{[Measures].[Current]} ON COLUMNS
,--NON EMPTY
{
[Date].[Calendar].[Date].ALLMEMBERS*
[Distributor].[Distributor Group].[Branch].ALLMEMBERS
-- [Distributor].[Distributor Group].[Branch].ALLMEMBERS --Need To Test
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
StrToSet
(@SaleType
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
-
{[Key Account].[Key Account].&[-7],[Key Account].[Key Account].&[-9] } ON COLUMNS
FROM
(
SELECT
StrToSet
(@KeyAccountKeyAccountSection
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
-
{[Distributor].[Distributor Group].[Branch].&[-7],[Distributor].[Distributor Group].[Branch].&[-9]} ON COLUMNS
FROM
(
SELECT
StrToSet
(@MeasureTypeMeasureType
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
{
[Analysis].[Analysis].&[2]
} ON COLUMNS
FROM
(
SELECT
StrToMember(@DateCalendarEnd) ON COLUMNS
FROM [Premium APE]
)
)
)
)
)
)
)
WHERE
(
[Analysis].[Analysis].&[2]
,IIF
(
StrToSet
(@MeasureTypeMeasureType
,CONSTRAINED
).Count
= 1
,StrToSet
(@MeasureTypeMeasureType
,CONSTRAINED
)
, [Measure Type].[Measure Type].CurrentMember
)
,IIF
(
StrToSet
(@KeyAccountKeyAccountSection
,CONSTRAINED
).Count
= 1
,StrToSet
(@KeyAccountKeyAccountSection
,CONSTRAINED
)
,[Key Account].[Key Account Section].CurrentMember
)
,IIF
(
StrToSet
(@SaleType
,CONSTRAINED
).Count
= 1
,StrToSet
(@SaleType
,CONSTRAINED
)
,[Sale Type].[Sale Type].CurrentMember
)
)
CELL PROPERTIES
VALUE
,BACK_COLOR
,FORE_COLOR
,FORMATTED_VALUE
,FORMAT_STRING
,FONT_NAME
,FONT_SIZE
,FONT_FLAGS;
May 26th, 2011 12:14pm
Hello bandlamudi123,
Are you trying to run this report with the created parameters named KeyAccount and KeyAccountKeyAccountSection in SSRS with the radial button "Internal" selected on the "General" tab, as well as including the parameters KeyAccount and KeyAccountKeyAccountSection
in the query itself???
Kind Regards,
WCC44
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 1:55pm
Hello bandlamudi123,
Are you trying to run this report with the created parameters named KeyAccount and KeyAccountKeyAccountSection in SSRS with the radial button "Internal" selected on the "General" tab, as well as including the parameters KeyAccount and KeyAccountKeyAccountSection
in the query itself???
Kind Regards,
WCC44
May 26th, 2011 1:55pm
yes ... i want to make it KeyAccount as visible and KeyAccountKeyAccountSection as internal ....
Thank you
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2011 2:26am
Hello banlamudi123,
Try running your report in management studio without the parameters to see if you get any errors. Then try running them with default values. Also try taking them out of the query and set them up in SSRS...
Try looking at these as well:
http://social.technet.microsoft.com/Forums/en-ZA/ppsmonitoringandanalytics/thread/38fde948-c7f2-4b40-8777-a283cc5f0d06
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/64fa39b9-9c2e-4a3d-a999-c2e9d2d75f00/
Kind Regards,
WCC44
May 27th, 2011 10:38am
This topic is archived. No further replies will be accepted.
Other recent topics
