Hi,
I built a cube from a flat file. All of my dimension key fields and measurements fields are from that flat file. The problem that the flat file still have othe fields that were not used as dimension key or measurement and the cube user want to see these other fields as part of the cube. If these other fields are not dimension or measurement how I should bring them to the cube to be seen by the cube user?
Please help!
Aref
Unfortunately No.
In order to return the information to the client application, you will have to include a column as part of the measure group or dimension. Take a look at the dimensions of type Fact, they are intended for the cases like yours.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Maybe what your looking for is a junk dimension.
Look at:
http://rkimball.com/html/designtipsPDF/DesignTips2003/KimballDT48DeClutter.pdf
I think gives you a more clean solution for your problem.
No comments:
Post a Comment