HI All,
Recently i got requirement like display Individual dimensions from default dimensions in purchase order.
These Individual dimensions i need to show in SSRS report.
protected Description GetDefaultDimensionAttributeName(DimensionDefault _dimensionDefault)
{
DimensionAttributeValueSetStorage dimStorage;
DimensionDefault HcmPositionDefaultDimension;
DimensionAttribute DimensionAttribute;
Counter i;
DimensionAttribute dimAttr;
DimensionAttributeValue dimAttrValue;
Common common;
DictTable dictTable;
str Name,Namecmp;
str value;
// make the dimension storage object
dimStorage = DimensionAttributeValueSetStorage::find(_dimensionDefault);
for (i=1 ; i<= dimStorage.elements() ; i++)
{
// get attribute select here.
select firstonly dimAttrValue
where dimAttrValue.RecId == dimStorage.getValueByIndex(i)
join dimAttr
where dimAttr.RecId == dimAttrValue.DimensionAttribute;
if (dimAttr && dimAttrValue)
{
dictTable = new DictTable(dimAttr.BackingEntityType);
common = dictTable.makeRecord();
if (common.TableId)
{
select common where common.(dimAttr.KeyAttribute) == dimAttrValue.EntityInstance;
Namecmp = dimAttr.Name;
//My requirement like i want only BusinessUnit dimensions
if(Namecmp like "BusinessUnit")
{
name = common.(dimAttr.NameAttribute); //Dimension Description
value = common.(dimAttr.ValueAttribute); //Dimension Value
}
}
}
}
return name;
}
Subscribe to:
Post Comments (Atom)
Create number sequence in D365 FO
Create the data type. Add code in the loadModule method of the appropriate NumberSeqModule subclass. Add a method to the module’s paramet...
-
Dialogbutton dialogButtonConfirm; ; dialogButtonConfirm = Box::yesNo("continue ", dialogButton::Yes, ...
-
Breakpoints Command Shortcut key Remove all breakpoints. CTRL+SHIFT+F9 I...
-
Just use the below code to remove the special character from the string. strRem('String','*'); You can replace * with...
No comments:
Post a Comment