I would like to be able to perform an NL Function against the G/L Entry Table but filter on the Dimensions that I can see in the G/L Entry Dimension Overview.
I am on Version 3.6 which only has two Global Dimensions. I have established 6 Dimensions in total.
I have created a number of Analysis Views but I do not have one that has the combination of Dimensions that I require.
I cannot create another view as it will take several days to generate due to the large number of transactions involved.
What I need is something like
=-nl(,"G/L Account","Net Change","No.","3025..3499","Date Filter","01/12/2010..31/12/2010","Dimension 3","xxx","Dimension 4","YYY")
Where Dimensions 3 & 4 are non Global Dimensions and are not in the same Analysis View.
I hope I have explained this well enough…
Date
Votes
1 comment
-
Jet Reports Historic Posts If dimensions 3 and 4 are advanced or shortcut dimensions then you should be able to filter on them by dimension name (Project, Area, etc.). If they are analysis view dimensions in different analysis views, you probably would have to create an analysis view that combines both of them.
Regards,
Hughes
Please sign in to leave a comment.