Hello!
I don't have a lot of experience with dimensional models so I've ran into this issue ( which in relational sorts out pretty easy )
Model: Dimensional
Task: Report should display only those products which price is > 4.50
So the problem is that there is a lot of prices ranging from 0 to 20000 price itself is a member not a measure. This seems a pretty straight forward task but I'm stuck with this. Would really appreciate any help. Thank you!
Quote from: mindNET on 02 Jun 2017 06:02:00 AM
Hello!
I don't have a lot of experience with dimensional models so I've ran into this issue ( which in relational sorts out pretty easy )
Model: Dimensional
Task: Report should display only those products which price is > 4.50
So the problem is that there is a lot of prices ranging from 0 to 20000 price itself is a member not a measure. This seems a pretty straight forward task but I'm stuck with this. Would really appreciate any help. Thank you!
Hi,
Can you explain how price is a member not a measure? It sounds like it should be a measure to me? Or are you saying it's an attribute of a Product member? Can you elaborate?
I'd be looking at using the filter function for this in a query calculation
eg filter( [your Product level], [your Price attribute or measure] > 4.50)
Does that give you the results you need?
MF.
Using filter was my first try but it ends up with an error
The argument at position 1 of the function '>' is invalid in data item 'Data Item1' of query 'Query1', expected one of the following types: 'value'.
Hi,
Like MFGF said, if you want to use filter function you have to have a measure value. Does the cube has any measure and which cube are you using?
Good luck
New guy
Quote from: New_Guy on 02 Jun 2017 07:14:46 AM
Hi,
Like MFGF said, if you want to use filter function you have to have a measure value. Does the cube has any measure and which cube are you using?
Good luck
New guy
As I've stated in my post above that Price is not a measure it's a separate hierarchy hence it does not fit the requirements for using filter function. The cube does have measures but they have nothing to do with the task that I'm trying to accomplish. If I understand your question correctly it's a microsoft cube.
So you might think of using except and just put all the price values in there, but there are always new prices being added so the slicer would not cover everything then. I though of using head or tail but again member index will shift whenever new price is added to the hierarchy.
Quote from: mindNET on 02 Jun 2017 07:30:04 AM
As I've stated in my post above that Price is not a measure it's a separate hierarchy hence it does not fit the requirements for using filter function. The cube does have measures but they have nothing to do with the task that I'm trying to accomplish. If I understand your question correctly it's a microsoft cube.
So you might think of using except and just put all the price values in there, but there are always new prices being added so the slicer would not cover everything then. I though of using head or tail but again member index will shift whenever new price is added to the hierarchy.
Hi,
I'm struggling to see the logic here if Price is a set of members in a different hierarchy. How does a Price member relate to a Product member? Do they share a common measure you could utilise? Can you explain more about the structure of your cube?
MF.