Using Targit 2k14 build 6624 I am facing this problem.
I have a cube using two measure groups from two separate DWH fact tables. First measure group contains invoiced lines and second measure group contains ordered lines. On all lines in both groups there is a field called "TRANSSTATUS" which can contain a 0 for invoiced or a 1 for ordered. This field serves as a foreign key for a dimension "Sales transaction status".
This works well when using the dimension in the grid (crosstab, table, chart), however, when I put the dimension as a criterion and open it for selection, it shows only one member "Invoiced".
I have unticked the "Filter criteria" from both options in the user settings, but the problem persists.
If I connect to the cube from Excel and create a pivot table and use the dimension as a filter, it works without incident.
What do I do to make sure that I can select "Ordered" from the dimension when used as a criterion?
[img=http://imgur.com/PGi7D03]Missing dimension members[/img]
Edited by user Monday, June 13, 2016 11:36:41 AM(UTC)
| Reason: Not specified