June 4, 2015 at 12:50 am
Hello, Please I am trying to use a sub cube to eliminate the values that has no value, the subcube works on its own, but when i try to use it to return parametervalues, the result I get is returning all values
this is the query
WITH
MEMBER
[MEASURES].[PARAMETERCAPTION]
AS
[PTF].[Cred].CURRENTMEMBER.MEMBER_CAPTION
MEMBER
[MEASURES].[PARAMETERVALUE]
AS
[PTF].[Cred].CURRENTMEMBER.UNIQUENAME
MEMBER
[MEASURES].[PARAMETERLEVEL]
AS
[PTF].[Cred].CURRENTMEMBER.LEVEL.ORDINAL
SELECT
{
[MEASURES].[PARAMETERCAPTION],
[MEASURES].[PARAMETERVALUE],
[MEASURES].[PARAMETERLEVEL]
}
ON COLUMNS,
[PTF].[Cred].ALLMEMBERS ON ROWS
FROM
(
select
(nonempty([PTF].[Cred].ALLMEMBERS,[Measures].[Acc Count]))
on columns
from
[MYCUBE]);
and also the parameter label in my report shows the values of the nulls as [PTF].[Cred].&[]
Please how can I pass the subcube in this case
June 4, 2015 at 1:51 am
the problem was with my subcube
select
(nonempty([PTF].[Cred].[cred].ALLMEMBERS,[Measures].[Acc Count]))
on columns
from
[MYCUBE]);
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply