| Name |
SetLinkedObsRowCount |
| Value |
 Expression: "
SELECT
(
SELECT COUNT(*)
FROM Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactInstitutionalRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactProgramRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactStudentSuccess_FirstYearSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactStudentSuccess_
SELECT
(
SELECT COUNT(*)
FROM Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactInstitutionalRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactProgramRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactStudentSuccess_FirstYearSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactStudentSuccess_TermSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK)
) AS TotalRowCount
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SetLinkedObsRowCount |
| Evaluate As Expression |
True |
| Expression |
"
SELECT
(
SELECT COUNT(*)
FROM Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactInstitutionalRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactProgramRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactStudentSuccess_FirstYearSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactStudentSuccess_ |
| ID |
d130eab6-28e0-46af-9e37-f9c5c1a5fb44 |
| Raise Changed Event |
False |
Properties
