How to get Financial Dimension Cost Center value for the Report!

(0) Share

Report

Posted on by Faqruddin

1,869

Dear all,

I need financial dimension cost center value for Purchase order confirmation report. I wrote following method on purchtable to get the value cost center for all purchase order reports. Please kindly have a look on below method and its not returning any value.

public str getCostCenterByDefaultDimension()
{
DimensionAttributeValueSetStorage dimStorage;
Str costCenter;
Counter i;

dimStorage = DimensionAttributeValueSetStorage::find(this.DefaultDimension);

for (i= 1 ; i<= dimStorage.elements() ; i++)
{

if(DimensionAttribute::find(dimStorage.getAttributeByIndex(i)).Name == 'CostCenter')
{
costCenter = dimStorage.getDisplayValueByIndex(i);
}
}

return costCenter;
}

Best Regards,

Faqru Shaik

*This post is locked for comments

All responses (31)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

Hi Faqru

You can try restarting the service SQL Server Reporting Services,

I happened something similar

Regards

Adrian M.
XB 1,867 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

That I show was an example you have to modify to your requirements.

If you want a display on vendTable do something like:

display DimensionValue displayCostCenterDimension()

{

DimensionAttributeValueSetStorage dimensionAttributeValueSetStorage ;

DimensionAttribute dimensionAttribute;

DimensionValue dimensionValue;

#define.DimensionName("CostCenter")

dimensionAttributeValueSetStorage = dimensionAttributeValueSetStorage::find(this.DefaultDimension);

dimensionAttribute = dimensionAttribute::findbyname(#DimensionName);

dimensionValue = dimensionAttributeValueSetStorage.getDisplayValueByDimensionAttribute(dimensionAttribute.recId);

return dimensionValue;

}

Of course this method have to be on VendTable.
Faqruddin 1,869 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

As a Job

O/P:

For vendor Form

Code in VednTable..

display DimensionValue displayCostCenterDimension()
{
DimensionAttributeValueSetStorage dimensionAttributeValueSetStorage ;
DimensionAttribute dimensionAttribute;
VendTable vendTable;
DimensionValue dimensionValue;
#define.DimensionName("CostCenter")
while select vendTable
{
dimensionAttributeValueSetStorage = dimensionAttributeValueSetStorage::find(vendTable.DefaultDimension);
dimensionAttribute = dimensionAttribute::findbyname(#DimensionName);
dimensionValue = dimensionAttributeValueSetStorage.getDisplayValueByDimensionAttribute(dimensionAttribute.recId);

}
return dimensionValue;
}

O/P:

Every vendor holds different cost center. But its giving only single cost center to all vendors.
Verified answer

XB 1,867 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

try this on a job

static void displayCostCenterDimension()

{

DimensionAttributeValueSetStorage dimensionAttributeValueSetStorage ;

DimensionAttribute dimensionAttribute;

VendTable vendTable;

DimensionValue dimensionValue;

#define.DimensionName("CostCenter")

while select vendTable

{

dimensionAttributeValueSetStorage = dimensionAttributeValueSetStorage::find(vendTable.DefaultDimension);

dimensionAttribute = dimensionAttribute::findbyname(#DimensionName);

dimensionValue = dimensionAttributeValueSetStorage.getDisplayValueByDimensionAttribute(dimensionAttribute.recId);

info(dimensionValue);

}

}
XB 1,867 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

of course you are doing a select firstonly you need to do a while select statement to check if code run ok and show all records
Faqruddin 1,869 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

Hi Javier,

I try that job for vendor form but its returning same Costcenter for all vendors. Check this..

display DimensionValue displayCostCenterDimension()
{
DimensionAttributeValueSetStorage dimensionAttributeValueSetStorage ;
DimensionAttribute dimensionAttribute;
VendTable vendTable;
DimensionValue dimensionValue;
//Nombre de la dimensión que buscaremos
#define.DimensionName("CostCenter")
select firstOnly vendTable;

dimensionAttributeValueSetStorage = dimensionAttributeValueSetStorage::find(vendTable.DefaultDimension);
dimensionAttribute = dimensionAttribute::findbyname(#DimensionName);
dimensionValue = dimensionAttributeValueSetStorage.getDisplayValueByDimensionAttribute(dimensionAttribute.recId);

return dimensionValue;

}

O/P:
XB 1,867 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

And what is the name of your dim?

With this code you have be able to read dim value.

axlearn.blogspot.com.es/.../3_26.html
Faqruddin 1,869 on at

Like (0)

Report

RE: How to get Financial Dimension Cost Center value for the Report!

NO..

public DimensionValue displayCostCenter()

{

DefaultDimensionView defaultDimensionView;

PurchTable purchTable;

select firstOnly DisplayValue from defaultDimensionView

where defaultDimensionView.DefaultDimension == purchTable.DefaultDimension

&& defaultDimensionView.Name == "CostCenter";

return defaultDimensionView.DisplayValue;

}
Mea_ 60,278 on at

Like (0)

Report
RE: How to get Financial Dimension Cost Center value for the Report!

Let's try another way:

DefaultDimensionView defaultDimensionView; select firstOnly DisplayValue from defaultDimensionView where defaultDimensionView.DefaultDimension == purchTable.DefaultDimension && defaultDimensionView.Name == "CostCenter";

Does this one return something ?
Mea_ 60,278 on at

Like (0)

Report
RE: How to get Financial Dimension Cost Center value for the Report!

I can see a record on your screenshot.

However, you are saying that DimensionAttribute::findByName("CostCenter") does not return a record. This method does not do anything special, just

select firstonly dimensionAttribute where dimensionAttribute.Name == _name

So either it returns a record or something is completely wrong here ...