This content has been marked as final. Show 9 replies
Create in this way add As LTS and create a new column in that column u can define the count,Now create a another colum and implement the conditon what u need
CASE WHEN Dim.status = ' Accepted THEN NEWCOL(COUNT(DIM.STATUS) ELSE END;
Try this and let me know the updates.
That exactly is my question. The where condition should be applicable only for that logical column. In a different logical column it might be a different where condition, but the table for both these logical columns would be same.
Also should this table be present as a LTS( the default LTS for this is a different fact)?
Use a FILTER operator - that should take care of you!
Will this expression work?
Filter(count(Dim.Status) Using("dim.status = 'accepted'))
That looks right, don't have an easy way to check but that syntax seems correct.1 person found this helpful
Just in case this also works
FILTER("Metric from Fact with ROW_WID" USING (Status = 'accepted'))
You may take any metric which is equivalent to count(fact.row_wid) in RPD
In the filter condition ( using) can we use a column whose table is not a LTS
Ex: Filter(count(Fact.Dollars) Using("dim.status = 'accepted'))
In the above example is the default LTS is the fact table, to use the above expression('Using' part)should I have the ' dim' table listed as a LTS too?
The suggest statement as Filter(count(Fact.Dollars) Using("dim.status = 'accepted'))1 person found this helpful
is based on Answers, this would care about the column is available in Subject Area or not thats it.
The same kind of functionality can get the using rpd.
There you might need to map/add (fact source properties and then map using pencil icon on 11g add button in 10g) the dim table to the fact
so that you can get the expression based on physical columns as
case when dim.status = 'accepted' then Fact.Dollars else 0 end
use Aggregate tab for sum;
Since you are using Fact.Dollars it suppose to be sum, ROW_WIDs go by counts
Hope this helps :) for more Qs send email
If helps mark
Edited by: ABujji on Feb 19, 2013 5:50 PM