If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

filter not correct result in calculated measure

Started by Behnamqmarsi, 10 Aug 2016 04:12:37 AM

Previous topic - Next topic

Behnamqmarsi

hi
i create a calculated measure with calculated query item in report studio (with Dimensional Functions)

tuple(parallelperiod(level(currentmember([CHQBOOKTYPE_Cube_H].[DimDate].[YearToMounth_Hierarachy])),1),[CHQCNT])

but
i define filter for calculated column , filter not give correct result

please help me

AnalyticsWithJay

Hi,

Please provide more info, such as what the result is vs what the expected result. What are you trying to achieve with your filter?

Behnamqmarsi

if filter (measure value) set >=0 result is correct

but  (measure value) set >0 result not view

MFGF

Quote from: Behnamqmarsi on 10 Aug 2016 07:56:35 AM
if filter (measure value) set >=0 result is correct

but  (measure value) set >0 result not view

Can you elaborate on what you mean by "filter"? Do you mean a slicer? Filter function in a query calculation? Detail filter?

MF.
Meep!

Behnamqmarsi

Quote from: MFGF on 10 Aug 2016 08:54:31 AM
Can you elaborate on what you mean by "filter"? Do you mean a slicer? Filter function in a query calculation? Detail filter?

MF.




Hi
i explain for you my problem

i have a case study that contain of sales information in different month of years

i have one measure As "Sales Amount"

i need defined a same measure "sales amount" for 6 month period for current member: "6 period measure"

so i create that by calculated query with dimensional functions .

in this stage every things works right and Ok

I defined a filter .
when i used this filter "sales amount measure" i get correct result
my problem is :
filter dose not work for "6 period measure" and did not get  any result.
now i want know how i can apply filter to "6 period measure"when run report

for example:
i want to filter  sellers who have "6 period measure">100000000
unfortunately  i do not understand hot to define appropriate expression for filter function

thank you for your help