Re: Design Question Again.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Ed,
Yes, you can do it. As I had said that if you do not create columns in the
fact table to hold 1 or 0, you can create a view for including the columns
that hold 1 or 0. However in either way, adding such values is necessary
since you need additive values for counting in OLAP analysis.

Hope this helps. Please feel free to let me know if you have any other
questions or concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================



.

Relevant Pages

  • RE: ServiceBase denies access to service name
    ... I encourage you to report this issue to ... Microsoft Online Community Support ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework)
  • Re: Auto Refresh Example
    ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ADO.NET OleDb connector problem with jet
    ... And if we are working on an Office Add-in, the Add-in will also be run in ... Microsoft Online Community Support ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Auto Refresh Example
    ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: App configuration for a service when running multiple instance
    ... Microsoft Online Community Support ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework)