Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can anyone suggest me how to create ad-hoc kind of report (table) where, I will be having dimension and measure selection and whichever I select, only those dimensions and measures should get display in table.
Thanks!
I did something like this in an app.
I use an extension so that the user can pick the Dimension that they want.
I load an inline table that contains the choices from the filter along with the actual field value that I need to get the data.
// Used to assign the correct field based on the selection made in filter on Patient Outcomes Sheet
Dimensions:
Load * Inline [
Display,Dim1
'By Facility','Facility'
'By District','District'
'By Region','Region'
'By MeasureDesc','MeasureDesc'
'By ReferralSource','ReferralSourceID'
'By PrimaryProgram','PrimaryProgramDesc'
'By SecondaryProgram','SecondaryProgramDesc'
'By DiagnosticGroup','DiagnosticGroupDesc'
'By MedicalDx','MedicalDxDesc'
'By FDScale','MeasureGroup_Scale'
'By EOC Destination','EOCDest'
];
In the table my dimension is defined as
$(='[' & only(Dim1) & ']')
The field in the filter extension is Display so that I can match it to the inline table.
Hope that helps as does what you want.
Hey Thanks for reply!
can you share any demo app for the same and one more thing which extension you have used.