asdb - what is it? Shold I back it up?

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Thanks,
Mark.mfine@.array.ca wrote:

Quote:

Originally Posted by

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.
>
My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Google turns up nothing obviously relevant. Ask the customer to
show you 'asdb' - maybe it's the name of another SQL or Access DB,
or maybe they meant something else but botched the name.|||Thaks.

Ed Murphy wrote:

Quote:

Originally Posted by

mfine@.array.ca wrote:
>

Quote:

Originally Posted by

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.

My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

>
Google turns up nothing obviously relevant. Ask the customer to
show you 'asdb' - maybe it's the name of another SQL or Access DB,
or maybe they meant something else but botched the name.

|||mfine@.array.ca wrote:

Quote:

Originally Posted by

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.
>
My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.

Is it perhaps "msdb"? "The msdb database is used by SQL Server, SQL
Server Enterprise Manager, and SQL Server Agent to store data,
including scheduling information and backup and restore history
information." (SQL Server 2000)

If that sounds like something you will make use of, then Books Online
has tips on backing it up. If that information isn't useful in your
disaster recovery plan, don't bother - you can use this database to
manage backups and automated maintenance, but you can do without it,
restore your customer's data onto a newly installed server.

We presume your customer's data is in a specially created database and
not in one of the built-in ones.

I suppose database creation date also is likely to reflect whether the
database was created during installation of SQL Server, or when you
started using it. But if the database was yours, then you'd know,
surely?

Is someone else keeping data on the same server?|||I believe this is the database that Arcserve backup for windows uses.
Its a product by Computer Associates.
HTH
Rob
(open it up. if you see tables like asfilename, ashost, asjob,
asjobmap,
then this is what it is)

mfine@.array.ca wrote:

Quote:

Originally Posted by

We developed a DB for our customer using MS Access and upsized it to
SQL Server. Our customer does daily back up of his DB and he asked me
whether or not 'asdb' should be backed up as well.
>
My question is: what is 'asdb' and whether or not it should be
backed up. Any information or web links will be appreciated.
>
Thanks,
Mark.

AS 2005 modeling question

Hello everybody!

We have three fact-tables with a classic hierarchical order:
-customer table
-order table
-order positions

one customer has multiple orders and one order has multiple order positions

and we have one dimension articles related to the position table.

Further we defined a count measure for each measure group.

The question is how can we connect the articles dimension (related to order positions measure group) to the customer measure group to get a count over customers? We tried to use m:n relations. It was not very fast (10 million fact rows).

Any ideas to model this 1:n scenario fast and clever ;-)?

Thanks in advance
Ole J.

I am not sure about what you mean about the customers table being a fact table. That is a dimension table. Perhaps you can explain further?

Next. In the order postions table you will only have to add the order number and the customer number to that fact table as keys like this:

-CustomerKey

-OrderKey

-OrderItemKey

-Measure.

You will do this in the ETL-process with SSIS(Integration services) when you load your fact table.

Your mistake is perhaps that you have separated orders and order line items in two different fact tables?

HTH

Thomas Ivarsson

|||Thanks Thomas for your first ideas. I would like to tell you a little bit more background.

The customer table is indeed a fact table because there are for example measures like lifetime-values and others... and further the focus of investigation is not only the customer name but the count of customers is more important.

The vision is to have a customer measure group with at least one measure customer count and one or more dimensions like customer sex or others...

And with order facts we want to analyze the count of orders (facts), the amount group (dimension) and so on.

Line items are interesting because of the count over line items, a dimension that filters some properties of the line items and further more.

Is it really necessary to join the tables before we build the cube? We thought that in AS2005 we can simply bring together the measure groups?

What we have done so far is we denormelized the tables in the following way:

Customer table:
CustomerID, CustomerSexID

Order table:
OrderID, AmountGroupID, CustomerID, CustomerSexID

OrderItems table:
OrderItemsID, OrderitemsDimensionID, OrderID, AmountGroupID, CustomerID, CustomerSexID

In BI Studio it looks like this:

MeasureGroup MeasureGroup MeasureGroup
Customer Order OrderItems
Dimension
CustomerSex X X X
OrderAmountGroup X X
OrderItemsDimension X

So if you anaylize rigth now the dimension CustomerSex you get the correct results for:
count customer
count order
count orderitems

But if you want to analyze the OrderItemsDimension you get only the correct results for the count OrderItems because of the fact that until now the Orders and Customers measure group are not related to the dimension OrderItemsDimension. So the question is how can you go the way back from the count orderitems to get a result for the orders or customer counts?

I hope you can now better imagine what i mean..? Any ideas?

Thanks in advance,
Ole J.|||Any ideas?

Thanks in advance!

Ole J.|||

Hello Ole. This looks like a complicated project. I am unable to see the complete picture of what you would like to do.

I am not sure if your best choice is to do data mining, build a cube or combine these approaches.

My recommendation is to have a look att www.Kimball.group and see if there is any design tips that can help you.

You can also have a look here(http://www.sqlserverdatamining.com)

In SSAS2005 the customer sex is an attribute within the customer dimension so I do not understand why you will build this as a single dimension.

Regards

Thomas Ivarsson

|||

If I understand the situation, you already have CustomerSex as a reference dimension in the OrderItems measure group and you just want to control the behavior of the values in the Cutomer and Order measure groups when a order item is specified in the query. (The cube wizard should create this design for you if you specify each of the three tables as both fact and dimension tables.) Try using the IgnoreUnrelatedDimensions property on the measure groups (see http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.measuregroup.ignoreunrelateddimensions.aspx).

Hope this helps

Area Chart - urgent Help

I have an Area Chart with four different values plotted on it, as 25th
Percentile, Median value, 75th Percentile and the Customer data.
Now that with SP1, we can specify FILL color, it has become very useful on
this Area chart. (mind you this is Simple Area chart).
However, in certain cases where the customer data completely falls above say
25th Percentile, the whole FILL area of 25th Percentile is overlapped with
the Customer data (and overtaken by Customer FIll color)
SO, I used for customer data, the background color as <Transparent>.
It works absolutely perfect (and as per the color I specify and the border)
in the LAYOUT window, but unfortunately, in the Preview Window it just messes
up..! (and so does when I actually deploy this chart on the Report Server)
I do not understand, why is the display in <Preview Window> any different
from the <Layout window> '
Pls. guide.Please read my responses on your other thread.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:64445861-60E1-407D-839F-7BA0F16BDCD4@.microsoft.com...
> I have an Area Chart with four different values plotted on it, as 25th
> Percentile, Median value, 75th Percentile and the Customer data.
> Now that with SP1, we can specify FILL color, it has become very useful on
> this Area chart. (mind you this is Simple Area chart).
> However, in certain cases where the customer data completely falls above
say
> 25th Percentile, the whole FILL area of 25th Percentile is overlapped with
> the Customer data (and overtaken by Customer FIll color)
> SO, I used for customer data, the background color as <Transparent>.
> It works absolutely perfect (and as per the color I specify and the
border)
> in the LAYOUT window, but unfortunately, in the Preview Window it just
messes
> up..! (and so does when I actually deploy this chart on the Report Server)
> I do not understand, why is the display in <Preview Window> any different
> from the <Layout window> '
> Pls. guide.

Area Chart - Is there a bug?

I have an Area Chart with four different values plotted on it, as 25th
Percentile, Median value, 75th Percentile and the Customer data.
Now that with SP1, we can specify FILL color, it has become very useful on
this Area chart. (mind you this is Simple Area chart).
However, in certain cases where the customer data completely falls above say
25th Percentile, the whole FILL area of 25th Percentile is overlapped with
the Customer data (and overtaken by Customer FIll color)
SO, I used for customer data, the background color as <Transparent>.
While chossing color and borders etc, the image that is brought up in the
<Layout> window matches with what selection I've made. However, in the
<Preview> window, the Chart takes GREEN fill-color (mind you, I've chosen
Transaparent color) and thus washes away the area for 25th Percentile
(considering the situation wher the customer data values fall above the 25th
Percentile)
jfyi: The palette I've chosen in this case is <Default> However, I've
already tried with all supported palettes..! They all result into some FILL
color for my customer data.
I do not understand, why is the display in <Preview Window> any different
from the <Layout window> '
The other strategy I've tried is, to plot Customer data as a solid black
line, but seems that feature is not supported (<Plot data as a line>), as
well.
Pls. guide.Several comments:
* "why is the display in <Preview Window> any different from the <Layout
window>"?
The layout window will not execute your queries to retrieve the datasets. It
will use random data to give you an approximation of how the chart will look
at runtime. In addition in layout mode expressions cannot be executed (e.g.
the expression result might depend on the dataset).
* Black line:
You need to use an expression (i.e. ="Black") in this particular case. Due
to a bug, the report designer does not write a constant chart color of Black
into the RDL-file.
* Combining area charts with line charts by using a "Transparent" fill
color:
Based on the RDL specification, Transparent is not a valid color. Therefore
you cannot use Transparent right now for the color property. Please try this
for now:
Color: e.g. White
Gradient: TopBottom
EndColor: ="Transparent"
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:A8AF6608-E6B1-4B44-851E-3F43E0FBCD62@.microsoft.com...
> I have an Area Chart with four different values plotted on it, as 25th
> Percentile, Median value, 75th Percentile and the Customer data.
> Now that with SP1, we can specify FILL color, it has become very useful on
> this Area chart. (mind you this is Simple Area chart).
> However, in certain cases where the customer data completely falls above
say
> 25th Percentile, the whole FILL area of 25th Percentile is overlapped with
> the Customer data (and overtaken by Customer FIll color)
> SO, I used for customer data, the background color as <Transparent>.
> While chossing color and borders etc, the image that is brought up in the
> <Layout> window matches with what selection I've made. However, in the
> <Preview> window, the Chart takes GREEN fill-color (mind you, I've chosen
> Transaparent color) and thus washes away the area for 25th Percentile
> (considering the situation wher the customer data values fall above the
25th
> Percentile)
> jfyi: The palette I've chosen in this case is <Default> However, I've
> already tried with all supported palettes..! They all result into some
FILL
> color for my customer data.
> I do not understand, why is the display in <Preview Window> any different
> from the <Layout window> '
> The other strategy I've tried is, to plot Customer data as a solid black
> line, but seems that feature is not supported (<Plot data as a line>), as
> well.
> Pls. guide.
>

Are SRS 2005 Reports Backwards Compatible?

I have a customer that is running SRS 2000 and unfortunately I only have SRS
2005 and Visual Studio 2005 in a test environement. Is it possible to
develop the reports in SRS 2005 and save them somehow that they can be
deployed on a 2000 instance of SRS?
If not, can I create the reports on in Visual Studio 2005 while I am hitting
their SRS 2000 instance?No on both accounts.
RS 2000 report designer only runs in VS 2003.
Theorectically you could hand edit the RDL and remove RS 2005 specific
elements but I wouldn't want to try to do that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jack Bender" <JackBender@.discussions.microsoft.com> wrote in message
news:DAC028CC-5F46-4F00-B14E-D6EE44A43913@.microsoft.com...
>I have a customer that is running SRS 2000 and unfortunately I only have
>SRS
> 2005 and Visual Studio 2005 in a test environement. Is it possible to
> develop the reports in SRS 2005 and save them somehow that they can be
> deployed on a 2000 instance of SRS?
> If not, can I create the reports on in Visual Studio 2005 while I am
> hitting
> their SRS 2000 instance?