Here is my scenario, I have multiple companies and each company has a listing of departments (which are predominantly the same) and I want to be able to provide a departmental manager a report of all of their departments by entity.
I created a tree in management reporter that looks like this to start
Company Unit Name Unit Description Dimensions
@Any Consolidated Summary of all Units
@Any Corporate Corporate Dept. Department 100:150
LSLP Corporate_LSLP Corporate_LSLP Department 100:150
CGLP Corporate_CGLP Corporate_CGLP Department 100:150
This continues for the same department for all entities, and then I would select the next department and do the same thing, and each of the entities is a reporting unit under the summary Department heading. However when I run the report there is no data showing. I selected @Any as the company on the report definition as well. If I remove my tree and select a specific company the report works so I know it isn't anything from the row or column definition.
Please Help what am I missing here?
Thank you
Lonnie
*This post is locked for comments
I have the same question (0)My first thought would be to make sure that the Department segment is in fact called Department in each of the companies.
When you choose @Any in the report definition, it will run for the company that you are currently logged in to in MR (shown at the bottom of MR). What company are you logged in to? If you take out the tree and use LSLP, does it populate with data? What about CGLP?
Community Member
2
babubaskaran@outloo...
2
Yng Lih
2