Thursday, September 12, 2013

Line Item Detail in Clarity


Line Item Detail is a powerful feature, but not often used in Clarity.  Line Item Detail allows users to enter detail below the lowest grain of the cube.  The most common use is for budget planning. Most cubes have an Account dimension that matches their chart of accounts. Some users may know that they have a few separate items they want to track, that all rollup into this account. For example, let's say we are planning insurance costs for an office, and there is only one Insurance account in the chart of accounts. By using Line Item Detail, a user could enter a line item for each type of insurance on the template. They get the detail they need for tracking, and the cube does not need to be changed. This can provide great flexibility when we just need a bit more detail on a given template.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.