Using Like operator in MDX
Hi All,
I am not able to get the result dataset using the following query for a report.
However, when I removed the following query from main dataset query then it is showing all the results. I have to get it done by today itself. Any help would be really appreciated.
ON COLUMNS
FROM
(
SELECT
Filter
(
[NQ_Supplier_AP].[Supplier].[Supplier].ALLMEMBERS
,
Instr
(
[NQ_Supplier_AP].[Supplier].CurrentMember.Properties('Member_Caption')@NQSupplierAPSupplier
)
> 0
Main Query:
SELECT
NON EMPTY
{[Measures].[Invoice Line Amount]} ON COLUMNS
,NON EMPTY
TopCount
(
[NQ_Supplier_AP].[Supplier Name].[Supplier Name].ALLMEMBERS,@TopN
,[Measures].[Invoice Line Amount]
)
*
[NQ_Supplier_AP].[Supplier Number].[Supplier Number].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToMember
(@FromInvoiceDateStandardDate
,CONSTRAINED
)
:
StrToMember
(@ToInvoiceDateStandardDate
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@APDistributionDetailsPLChargeType
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CategorySubCategoryName
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@CategoryCategoryName
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
Filter
(
[NQ_Supplier_AP].[Supplier].[Supplier].ALLMEMBERS
,
Instr
(
[NQ_Supplier_AP].[Supplier].CurrentMember.Properties('Member_Caption')@NQSupplierAPSupplier
)
> 0
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@ChargeToBranchBranch
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@ChargeToBranchDistrictName
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@ChargeToBranchRegionName
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
StrToSet
(@ChargeToBranchOrg
,CONSTRAINED
) ON COLUMNS
FROM [TopSuppliersList]
)
)
)
)
)
)
)
)
);
Thanks
Tarak
May 9th, 2011 3:29pm
Tarak,
Have you refered below URL's,
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/380ee5d2-3b97-41d9-9b4d-613df7903fa4
http://road-blogs.blogspot.com/2010/04/searching-substrings-in-mdx.html
Above links should answer your question.
Thanks
KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 4:15pm
Thanks Kumar for your quick reply. I know these two blogs previously. In my scenario, I have a top count function along with the topn parameter in the main dataset. To get the Top N parameter in my report, I edited the query manually. After I edited the
query , I am unable to see the result set.
However, I was able to get it resolved.
Thanks
Tarak.
May 10th, 2011 1:10am
Hi Tarak,
If you issue has been resolved, please marked this thread "As Answered" or let us know if you have more issues or concerns.
Thanks
KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2011 9:46am
This topic is archived. No further replies will be accepted.
Other recent topics
