Hello,
I am working on a requested feature for procurement in 2012.
Essentially the purchasing agents want a view where they can filter purchase
requisitions based on the presence of a line that has been distributed in whole
or part to a selected company. We use the "ProfitCenter" financial dimension to represent the "company" and a purchase requisition line can be distributed
to any number of companies.
From what I have found on forums, etc it appears the only
approach to getting the value for a specific dimension involves looping
individually through the segments for each hierarchy based on the segment count.
I am currently assuming only one hierarchy in the case of requisition lines. Is
that a correct assumption?
Because the segments are potentially dynamic I see no good way to
account for that in a query but I wanted to see if there were approaches I had
not thought of or an existing class that is not documented well. I know that I want
the “ProfitCenter” dimension but using a
“LIKE” query doesn’t seem the best
approach. I am not familiar with the dimension architecture in 2012 but it doesn’t
seem to lend itself well to queries. Is the best I can hope for to count on the
ProfitCenter being the second part of the DimensionAttributeValueCombination.DisplayValue
field and using a LIKE query to try to filter?
Right now I have the following:
Join PurchReqLine.SourceDocumentLine to SourceDocumentLine.RecId (1 to 1)
Join SourceDocumentLine.RecId to AccountingDistribution.SourceDocumentLine (1 to many)
Join AccountingDistributionLedgerDimension to DimensionAttributeValueCombination.RecId (1 to 1)
WHERE DimensionAttributeValueCombination.DisplayValue is LIKE"*-XXX*" where XXX is the value selected by the user to filter to
Any better ideas out there? What am I missing? I am still not familiar with the Dimension architecture in 2012 to be honest and I am having a difficult time finding technical documentation on it. Any help or advice would be greatly appreciated :)
Thanks!
AnnaP
