Weird Paging behaviour with additional measures from CSV

Hi,

we have the following weird behaviour, when we want to filter via pages with additional Data from a csv.

Setup:
1.) Issue Import from Jira, with additional properties/dimensions to filter, e.g. Release Name (Text field)
2.) CSV Import with Time, IssueKey and Measure

Works:
Rows: Issues
Columns (Measure (the imported ones)
Page: Time

It was mentioned in the forum, that you have to set the DefaultContext for the measures to work, so what we do is create a calculated measure:

DefaultContext(
[Measures].[Imported Measure],
[Time].CurrentHierachyMember,
[Issue].CurrentHierachyMember 
)

As a result, the measure would be the same for each Release Name.

BUT: When I want to filter the Issue now by Release Name, no results are returned. If I remove the NonEmpty Setting from the Rows, no filtering is applied at all.

Could you maybe point me in the right direction?

Best regards,
Alex

@thealexauer

Try this code (with double opening and closing parenthesis)


DefaultContext((
[Measures].[Imported Measure],
[Time].CurrentHierachyMember,
[Issue].CurrentHierachyMember 
))

Martins / eazyBI

Hello @martins.vanags,

I tried that, unfortunately didn’t help.

Best regards,
Alex

@thealexauer
Please reach out to support@eazybi.com and provide more details on your column mapping where you define how to import data from additional CSV file.

Martins / eazyBI support