Creating Cube report - with Parameter
In case of filtering cube records with input of user
parameters we need to override Contract
class in AX.
The parameter value which will be selected by user will not be
in fully qualified parameter which is expected by MDX query. Hence we need to
use UI Builder class where we
implement conversion of user entered value to fully qualified format.
Let’s proceed with creating a report for APTrial by adding
company as parameter.
Creation of Contract Class
Create a Contract Class for APTrialReport and reference the
UIBuilder class and Report name.
Creation of UI Builder class
Components of UI
Builder class
·
Class Declaration extending SrsReportDataContractUIBuilder.
·
Build method which builds dialog and dialog controls.
·
getFromDialog() to get the value from dialog and
set it to parameter.
·
postRun() to register all lookup methods.
·
processRangeValues()-To convert user entered
value to fully qualified value.(customized)
·
Lookup methods.
Copy the code as per below screenshot.
Build method
getFromDialog
postRun
ProcessRangeValues
/// <summary>
/// This method is
used to splits range values based on delimiter.
/// </summary>
/// <param
name="_values">
/// Passing query
criteria values.
/// </param>
/// <param
name="_path">
/// fully qulified
string for MDX values.
/// </param>
/// <param
name="_delimiter">
/// Passing delimiter
to seperate values.
/// </param>
/// <param
name="_agencyId">
/// Passing agency
code to seperate values.
/// </param>
/// <returns>
/// Returns splited
values.
/// </returns>
private AifDetail
processRangeValues(AifDetail _values, str
_path, str _delimiter, str _agencyId = "")
{
List rangeParameterValuesList;
ListEnumerator listEnumerator;
List agencyList;
ListEnumerator
agencyListEnumerator;
AifDetail
rangeParameterValuesString;
rangeParameterValuesString = '';
rangeParameterValuesList =
strSplit(_values, _delimiter);
if (_agencyId != #Empty)
{
agencyList = strSplit(_agencyId, _delimiter);
agencyListEnumerator = agencyList.getEnumerator();
while (agencyListEnumerator.moveNext())
{
if (strLRTrim(agencyListEnumerator.current())
!= '')
{
if
(rangeParameterValuesList)
{
listEnumerator = rangeParameterValuesList.getEnumerator();
while
(listEnumerator.moveNext())
{
if (strLRTrim(listEnumerator.current()) != '')
{
rangeParameterValuesString += _path +
strLRTrim(agencyListEnumerator.current()) +']&['
+ strLRTrim(listEnumerator.current()) + ']'
+ _delimiter;
}
}
}
}
}
}
else
{
if (rangeParameterValuesList)
{
listEnumerator = rangeParameterValuesList.getEnumerator();
while (listEnumerator.moveNext())
{
if
(strLRTrim(listEnumerator.current()) != '')
{
rangeParameterValuesString += _path +
strLRTrim(listEnumerator.current()) + ']' +
_delimiter;
}
}
}
}
return subStr(rangeParameterValuesString,
0, strLen(rangeParameterValuesString)
- 1);
}
Lookup method
Compile the UIBuilder class and Contract class.
Create MDX Query with Parameter
Create a MDX query with AgencyMDX as parameter.
Click Execute button.
Click OK.
Create a precision design just as the report developed before. Deploy the report.
Create an output menu item
to open the report.
