Forum Stats

  • 3,872,648 Users
  • 2,266,449 Discussions
  • 7,911,275 Comments

Discussions

How to filter the report based on a fact?

Chandranshu Bhardwaj
Chandranshu Bhardwaj Member Posts: 36
edited Dec 4, 2019 9:05AM in Enterprise Manager

Hi Folks,

We have a requirement in which we need to filter the data based on a fact.

Is there any efficient way to do that? I tried below approach using another analysis as a filter but it didn't work out.

I created two analysis. The SubAnalysis gets all products where its Quantity is 2, using the selection step.  The SubAnalysis is then used as a filter report on the products in the MainAnalysis.

The main analysis should only be giving records with product quantity of 2, but instead is evaluating all the products.  It is disregarding the selection step (it shows correctly when running just the subanalysis).  What needs to be done to the subanalysis so that only products with quantity of 2 is used in the MainAnalysis?  Is there a different way other than selection step to only list products that have a certain item quantity , i.e. like using the “Having” clause in SQL?

Thanks,

Chandranshu

Chandranshu Bhardwaj

Answers