Here we will see how to get the default Dimension from the table GeneralJournalAccountEntryEntity.
1. Add DimensionCombinationEntity as DS
2. Add a relation with LedgerDimension and Recid as shown below.
3. Add the field Display value from DimensionCombination DS. This will give you the Default Dimension for GeneralJournalAccountEntryEntity.
Use the standard flexibility of the queries
The standard queries already support a level of flexibility with predefined functions. You can read more about that in this blog post:
http://daxmusings.codecrib.com/2013/07/custom-query-range-functions-using.html
The class “SysQueryRangeUtil” contains several predefined methods which can be used to make your query more dynamic. The format is plain and simple: ( some code ), you only need the parentheses around the method.
Just to explain how this can be used, here are some samples:
Many other scenarios are possible. This second option gives you the ultimate flexibility to create dynamic queries.
In Microsoft Dynamics 365 Finance & Operations, SSRS reports are deployed to the SSRS server and stored in the ReportServer database. W...
