Comparing Financial values across random dates

I submitted this issue to the reporting services thread, but I'm beginning to think I may have to do something in SSAS:

I want to enable my users to select 2 random month end dates in a report parameter. After selecting these dates, I want to be able to take the corresponding financial values, be able to line them up next to each other in a report, and calculate the difference. Obviously in a matrix I can line the values up, but I am then not able to calc a difference. I do have a time hierarchy that allows me to do this across dates at the same level of granularity, i.e. year to year, qtr to qtr, etc., but if my users want to compare February month end to November month end, it's a problem. I am more than willing to add calculated members to the cube to get this done, I just haven't figured out the MDX for it.

Thanks in Advance...

I think this can be done without any calculated members, simply by using the following query:

SELECT

{Measures.ImportantFinancialValue1, Measures.ImportantFinancialValue2, ...} ON COLUMNS

, {Time.Date1, Time.Date2} ON ROWS

FROM Cube

HTH,

Mosha (http://www.mosha.com/msolap)

|||

Mosha-

Thanks for your quick response. I am using SSAS on top of SSRS, and am trying to avoid writing MDX as these reports may get very involved. Can I replicate this in a calc'd member, can it be dynamic enough to accept values at runtime?

|||I am supposed to find out the total number of open account between February - April and i am having difficulties. Below is a working statement for SQL which i am supposed to do in MDX for my Cube:

SELECT COUNT(*) AS Expr1

FROM ConsumerAccount

WHERE (DATEPART(yyyy, AccountOpenedDate) = '2007')

AND (DATEPART(mm, AccountOpenedDate) IN (02, 03, 04))

I have a cube called Batch process, column AccountOpenedDate and CrearedOnDate, how do i do it

comparing data between two tables...

I would like to compare data across two tables. I have part
information in a table. I get a new set of information periodically.
I would like to compare my new info to my old info. I recognize that
doing a compare of every attribute of every part will take FOREVER. Is
there some way I can do a "diff" based on the columns that I care
about?

Thanks!

--gloria"gloria" <gurbanic@.gmail.com> wrote in message
news:1108584926.680623.281960@.g14g2000cwa.googlegr oups.com...
>I would like to compare data across two tables. I have part
> information in a table. I get a new set of information periodically.
> I would like to compare my new info to my old info. I recognize that
> doing a compare of every attribute of every part will take FOREVER. Is
> there some way I can do a "diff" based on the columns that I care
> about?
> Thanks!
> --gloria

No idea - your desciption isn't very clear (to me), so I suggest you post
some CREATE TABLE and INSERT statements to show exactly what you want:

http://www.aspfaq.com/etiquette.asp?id=5006

But in general, you can do something like this:

select *
from dbo.MyTable1 t1 join dbo.MyTable2 t2
on t1.KeyColumn = t2.KeyColumn
where t1.col1 <> t2.col1
or t1.col2 <> t2.col2
or ... /* other columns here */

Simon|||Simon,

Your general code snippet tells me what I need to do. Thanks.

--gloria

ps. Thanks for the etiquette tip. I will do this in future. :)

Comparing data across two databases

Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
([url]http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx[/u
rl])
"Harish Mohanbabu" wrote:

> Hi,
> I have two identical databases (Production and Testing) sitting in differe
nt
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.sqlsql

Comparing data across two databases

Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:

> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.

Comparing data across two databases

Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.

Communication link failure

I am running an SSIS packsge across 2 servers. There at 33 Mil rows being copied over. At 5.6 mil rows I get this

[OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Protocol error in TDS stream". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: The specified network name is no longer available. ".

[DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Is there any known cause of this?

Thanks

Looks like a connection problem and that something, somewhere starts to drop packets or even the connection. You might have to enlist the help of the network guys if such people exist where you're at.