Hi All,

I am designing a warehouse for an ISP Billing system, for this purpose
i need to have two members (Customer Phone Number & Customer Name) on
same Level. I will not be using these two members simeltaneously, i.e.
Only one member will be using for analysis at one time, either by Phone
Number or Customer Name.

Any suggestions about how to create the warehouse that can address this
issue, and also how will be using it in OLAP ?.

I read some where on the internet that using a "Star Flake Schema" can
solve this problem, but i am not sure how :s
Any suggestions or recommendations ???


Regards,
Mansoor

you might consider creating two hierarchies (one for name, one for number)
and refering to the required hierarchy appropriately.

Cheers

DG

"Muhammad Mansoor" wrote:

Member Name column of Dimension :
CONVERT(VARCHAR(10),"dbo"."YourCube"."YourField") + ' ' +
"dbo"."YourCube"."YourField2"

The Convert is great for give for ex. all Tel-Numbers the same length.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!