Basic Fact Table Design Question

I'm not sure if this is the proper board....but....

I have a sales data from two different cost centers that generate the same data. When setting up my OLAP db, should I:

(1) design two fact tables that would have the same attributes,

(2) one fact table and one dimension table that contained a key field and a sales type field, or

(3) a fact table in which one of the attributes was the sales type field.

Thanks

Do the facts from the different cost centers represent the different instances of the same business process or event? If so, then they should be modeled as a single fact. Another way to approach this is to ask, "Would my users consider these to be the same thing and therefore would expect these to be in the same place in the DW?".

If you model these as a single fact, the cost center would be best handled in a dimension. Sounds like it would have low cardinality. (Is it possible you would ever have more than two cost centers? Many organizations have hundreds or even thousands of cost centers.)

B.

|||Cost center was probably a bad term. The business makes money selling stuff and performing services. They want total sales data and then sales broken between sales and services. The facts are pretty much the same: amount, date, cost of sale/service, etc. I thought a dimension table would work but it's going to be a table with an attribute that has only one of two conditions, plus a key field and a foreign key in the fact table. Seems like a lot of work for a simple A/B field.|||

I think option 2 is the better, but I need to understand some more requirements to decide.

Create a dimension is better, because tomorrow if you have more cost centers, your structure will be more flexible.

But option 3 is not bad...

Regards!

|||

This sounds like a line item fact table. For example, I bring my car in for repairs and what not, I receive a bill (an invoice). On that bill, there will be items for various parts and labor for various services, each with the number of units consumed, a price per unit, and the total cost for that line.

Each item purchased, it's code, name, base price, etc., belongs in a "product" dimension. We may identify each of these products as belonging to a "Parts" or "Service" category, but that catorigation too would belong in the dimension table.

Take a look at the Kimball book, "The Data Warehouse Toolkit", Chapters 2 & 5, for more ideas on this.

Good luck,

B.

barcode missing when printing from reporting services

I am using a barcode font 39 to generate barcodes in some reports. If I
reader the report and save it to a excel spreedsheet and print then the
report prints fine with the barcode.
If while I am in the browser I use the reporting services print engine the
barcode comes out as the numbers ie *12345* instead of the barcode font. The
numbers also come up in the preview of the printing.
I have installed the font on the local and reporting service computersI have just also found that if I export to Excel the barcode works but if I
export to PDF it doesn't.
"John230873" wrote:
> I am using a barcode font 39 to generate barcodes in some reports. If I
> reader the report and save it to a excel spreedsheet and print then the
> report prints fine with the barcode.
> If while I am in the browser I use the reporting services print engine the
> barcode comes out as the numbers ie *12345* instead of the barcode font. The
> numbers also come up in the preview of the printing.
> I have installed the font on the local and reporting service computers|||John,
I had the same problem. I wish Microsoft would release a fix to the problem
but I found a work-around by making the textbox (that holds the barcode in
the [rdl]) 3 times larger than the required size. This will of course mess
up your design.
Frank
"John230873" wrote:
> I have just also found that if I export to Excel the barcode works but if I
> export to PDF it doesn't.
> "John230873" wrote:
> > I am using a barcode font 39 to generate barcodes in some reports. If I
> > reader the report and save it to a excel spreedsheet and print then the
> > report prints fine with the barcode.
> >
> > If while I am in the browser I use the reporting services print engine the
> > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > numbers also come up in the preview of the printing.
> >
> > I have installed the font on the local and reporting service computers|||I am using a barcode and it is working perfectly. I had to find an assembly
for the solution which can be found here...
http://www.bizfonts.com/MicrosoftReportingServices/
HTH
"Frank" wrote:
> John,
> I had the same problem. I wish Microsoft would release a fix to the problem
> but I found a work-around by making the textbox (that holds the barcode in
> the [rdl]) 3 times larger than the required size. This will of course mess
> up your design.
> Frank
> "John230873" wrote:
> > I have just also found that if I export to Excel the barcode works but if I
> > export to PDF it doesn't.
> >
> > "John230873" wrote:
> >
> > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > reader the report and save it to a excel spreedsheet and print then the
> > > report prints fine with the barcode.
> > >
> > > If while I am in the browser I use the reporting services print engine the
> > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > numbers also come up in the preview of the printing.
> > >
> > > I have installed the font on the local and reporting service computers|||I need to generate a report with barcodes.
Are there any samples available that will show me how to do this?
Do I need to purchase a third-party component?
Thanks,
Scott
"DigitalVixen" wrote:
> I am using a barcode and it is working perfectly. I had to find an assembly
> for the solution which can be found here...
> http://www.bizfonts.com/MicrosoftReportingServices/
> HTH
> "Frank" wrote:
> > John,
> >
> > I had the same problem. I wish Microsoft would release a fix to the problem
> > but I found a work-around by making the textbox (that holds the barcode in
> > the [rdl]) 3 times larger than the required size. This will of course mess
> > up your design.
> >
> > Frank
> >
> > "John230873" wrote:
> >
> > > I have just also found that if I export to Excel the barcode works but if I
> > > export to PDF it doesn't.
> > >
> > > "John230873" wrote:
> > >
> > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > reader the report and save it to a excel spreedsheet and print then the
> > > > report prints fine with the barcode.
> > > >
> > > > If while I am in the browser I use the reporting services print engine the
> > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > numbers also come up in the preview of the printing.
> > > >
> > > > I have installed the font on the local and reporting service computers|||I too tried to use the assembly, but it did not fix the problem? Any
suggestions? I follwed the directions to a "T". Did you have to "tweak"
anything to get it to work for you?
"DigitalVixen" wrote:
> I am using a barcode and it is working perfectly. I had to find an assembly
> for the solution which can be found here...
> http://www.bizfonts.com/MicrosoftReportingServices/
> HTH
> "Frank" wrote:
> > John,
> >
> > I had the same problem. I wish Microsoft would release a fix to the problem
> > but I found a work-around by making the textbox (that holds the barcode in
> > the [rdl]) 3 times larger than the required size. This will of course mess
> > up your design.
> >
> > Frank
> >
> > "John230873" wrote:
> >
> > > I have just also found that if I export to Excel the barcode works but if I
> > > export to PDF it doesn't.
> > >
> > > "John230873" wrote:
> > >
> > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > reader the report and save it to a excel spreedsheet and print then the
> > > > report prints fine with the barcode.
> > > >
> > > > If while I am in the browser I use the reporting services print engine the
> > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > numbers also come up in the preview of the printing.
> > > >
> > > > I have installed the font on the local and reporting service computers|||This is the best barcode solution for Reporting Services.
All export file formats supported!!!
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
"HeroTheCat" wrote:
> I too tried to use the assembly, but it did not fix the problem? Any
> suggestions? I follwed the directions to a "T". Did you have to "tweak"
> anything to get it to work for you?
> "DigitalVixen" wrote:
> > I am using a barcode and it is working perfectly. I had to find an assembly
> > for the solution which can be found here...
> >
> > http://www.bizfonts.com/MicrosoftReportingServices/
> >
> > HTH
> >
> > "Frank" wrote:
> >
> > > John,
> > >
> > > I had the same problem. I wish Microsoft would release a fix to the problem
> > > but I found a work-around by making the textbox (that holds the barcode in
> > > the [rdl]) 3 times larger than the required size. This will of course mess
> > > up your design.
> > >
> > > Frank
> > >
> > > "John230873" wrote:
> > >
> > > > I have just also found that if I export to Excel the barcode works but if I
> > > > export to PDF it doesn't.
> > > >
> > > > "John230873" wrote:
> > > >
> > > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > > reader the report and save it to a excel spreedsheet and print then the
> > > > > report prints fine with the barcode.
> > > > >
> > > > > If while I am in the browser I use the reporting services print engine the
> > > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > > numbers also come up in the preview of the printing.
> > > > >
> > > > > I have installed the font on the local and reporting service computers

Barcode Control

Hi,
I am searching for a free tool to generate Barcodes in SQL Report Services.
Has anyone an idea?
Regards OttoOn Oct 9, 3:57 pm, "Otto Hermann" <entwickl...@.idicos.de> wrote:
> Hi,
> I am searching for a free tool to generate Barcodes in SQL Report Services.
> Has anyone an idea?
> Regards Otto
This has been a commonly asked question in this Usenet group. The
closest you will most likely come to a free add-in can be found here:
http://www.technoriversoft.com/freebarcodesoftware.html
Otherwise, there are several that are available for a fee.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

backuping logins + passwords.

I can backup my logins but without passwords....using SQL 2005 , generate sql scripts...

any idea i can generate a SQL script with the passwords in cleartext? i like to recreate them in my test database later.

As MSSQL 2005 doesn't store passwords (it stores only password hashes), there is no way to get them in clear text. If you want to back up your logins, you should backup master database; if you want to thransfer them to another server, you should use the DTS "Transfer Login Task" (just don't know analogue in MSSQL 2005 SSIS, it is possible that task didn't change the name).

Anyway, maybe it would be useful : http://search.microsoft.com/results.aspx?q=Transfer+Logins+and+Passwords+Between+Instances+of+SQL+Server&l=1&mkt=en-US&FORM=QBME1