DECLARE @ReportPath varchar(max) = '/Italy/Strade_Province'
--DECLARE @ReportPath varchar(max) = '/Italy/Strade_Region'
DECLARE @ReportDate datetime = dateadd(day,-5,getdate())
declare @ParameterName varchar(50)
declare @ParameterValue varchar(max)
declare @S varchar(max)
declare @R varchar(max)
declare @rw int
CREATE TABLE #tempUncachedReports
(
RowNo int
,ReportName varchar(1000)
,ParameterValue varchar(max)
)
CREATE TABLE #temp
(
ReportName varchar(1000)
,ParameterName varchar(1000)
,ParameterValue varchar(max)
,RowNo int
)
/*Insert uncached not in report*/
INSERT INTO #tempUncachedReports
SELECT rank() over(order by ItemPath,ParameterValues) as rowNo,ItemPath,ParameterValues
from (
select distinct ItemPath,replace(replace(replace(replace(replace(cast([Parameters] as nvarchar(max)),'&','#'),'%5B','['),'%5D',']'),'%26','&'),'%20',' ') as ParameterValues
from dbo.ExecutionLog3
where Timestart >= @ReportDate
and ItemPath like @ReportPath
--and format = 'RPL'
and Source = 'Live'
) as a
DECLARE @LoopCounter int = 1
DECLARE @MaxVal int = (select max(RowNo) from #tempUncachedReports)
WHILE (@LoopCounter <=@MaxVal)
BEGIN
SET @R = (select ReportName from #tempUncachedReports where RowNo=@LoopCounter)
SET @S = (select ParameterValue from #tempUncachedReports where RowNo=@LoopCounter)
SET @rw = (select RowNo from #tempUncachedReports where RowNo=@LoopCounter)
while len(@S) > 0
begin
set @ParameterName = left(@S, charindex('=', @S+'=')-1)
set @ParameterValue = replace(left(@S, charindex('#', @S+'#')-1), @ParameterName + '=','')
set @S = stuff(@S, 1, charindex('#', @S+'#'), '')
insert into #temp
(
ReportName
,ParameterName
,ParameterValue
,RowNo
)
SELECT @R as ReportName,@ParameterName as ParameterName,@ParameterValue as Parameter,@rw as RowNo
end
SET @LoopCounter += 1
END
--Takes into account multiselect parameters
select Main.ReportName, Main.ParameterName, ParameterValue=replace(Left(Main.ParameterValue,Len(Main.ParameterValue)-1),'&','&'),RowNo
from
(
select distinct ReportName, ParameterName,RowNo,
replace(replace((
SELECT a1.ParameterValue + ',' as ParameterValue
from #temp a1
where a1.ReportName = a2.ReportName
and a1.ParameterName = a2.ParameterName
and a1.RowNo = a2.RowNo
ORDER BY a1.ParameterName
FOR XML Path('')
),'<ParameterValue>',''),'</ParameterValue>','') as ParameterValue
from #temp a2
) Main
order by RowNo,ParameterName
--Regular, no multiselect
--select * from #temp
DROP TABLE #temp
DROP TABLE #tempUncachedReports
Friday, 24 March 2017
Single cache script
USE [ReportingSubscriptions]
GO
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
DROP TABLE #temp
IF OBJECT_ID('tempdb..#tempUncachedReports') IS NOT NULL
DROP TABLE #tempUncachedReports
DECLARE @ReportPath varchar(max) = '/Italy/Strade_Province'
DECLARE @ReportDate datetime = dateadd(day,-1,getdate())
declare @ParameterName varchar(50)
declare @ParameterValue varchar(max)
declare @S varchar(max)
declare @R varchar(max)
declare @rw int
CREATE TABLE #tempUncachedReports
(
RowNo int
,ReportName varchar(1000)
,ParameterValue varchar(max)
)
CREATE TABLE #temp
(
ReportName varchar(1000)
,ParameterName varchar(1000)
,ParameterValue varchar(max)
,RowNo int
)
/*Insert uncached not in report*/
INSERT INTO #tempUncachedReports
SELECT rank() over(order by ItemPath,ParameterValues) as rowNo,ItemPath,ParameterValues
from (
select distinct ItemPath,replace(replace(replace(replace(replace(cast([Parameters] as nvarchar(max)),'&','#'),'%5B','['),'%5D',']'),'%26','&'),'%20',' ') as ParameterValues
from [ReportServer].dbo.ExecutionLog3
where Timestart >= @ReportDate
and ItemPath like @ReportPath
--and format = 'RPL'
and Source = 'Live'
) as a
DECLARE @LoopCounter int = 1
DECLARE @MaxVal int = (select max(RowNo) from #tempUncachedReports)
WHILE (@LoopCounter <=@MaxVal)
BEGIN
SET @R = (select ReportName from #tempUncachedReports where RowNo=@LoopCounter)
SET @S = (select ParameterValue from #tempUncachedReports where RowNo=@LoopCounter)
SET @rw = (select RowNo from #tempUncachedReports where RowNo=@LoopCounter)
while len(@S) > 0
begin
set @ParameterName = left(@S, charindex('=', @S+'=')-1)
set @ParameterValue = replace(left(@S, charindex('#', @S+'#')-1), @ParameterName + '=','')
set @S = stuff(@S, 1, charindex('#', @S+'#'), '')
insert into #temp
(
ReportName
,ParameterName
,ParameterValue
,RowNo
)
SELECT @R as ReportName,@ParameterName as ParameterName,@ParameterValue as Parameter,@rw as RowNo
end
SET @LoopCounter += 1
END
--select * from #temp
--select * from #tempUncachedReports
set @rw = (select max(RowNo) from #temp)
set @LoopCounter = 1
WHILE (@LoopCounter <=@MaxVal)
BEGIN
INSERT INTO [Italy].[ALD_Province]
([WholesalerWholesaler]
,[WholesalerSubGroup]
,[MarketCategory]
,[PackCategory]
,[GenericStatus]
,[VALUEUNITS]
,[Region]
,[PERIOD]
,[RANGE]
,[MICROBRICK]
,[Province]
,[MICROBRICKSelected]
,[PrescriptionStatus]
,[ReimbursementStatus]
,[Manufacturer]
,[ProductType]
,[Product]
,[ActiveFlag]
,[Ordering]
,[NewRow]
,[WID]
)
select distinct
WholesalerWholesaler
,WholesalerSubGroup
,MarketCategory
,PackCategory
,GenericStatus
,VALUEUNITS
,Region
,PERIOD
,[RANGE]
,MICROBRICK
,Province
,MICROBRICKSelected
,PrescriptionStatus
,ReimbursementStatus
,Manufacturer = null
,ProductType = null
,Product = null
,1 as ActiveFlag
,1 as Ordering
,1 as NewRow
,CONVERT(UNIQUEIDENTIFIER, WID) AS WID
from
(
select ParameterValue as value, ParameterName as columnname
from #temp
WHERE RowNo = @LoopCounter
) d
pivot
(
max(value)
for columnname in (
GenericStatus
,Manufacturer
,MarketCategory
,MICROBRICK
,MICROBRICKSelected
,PackCategory
,PERIOD
,PrescriptionStatus
,Product
,ProductType
,Province
,RANGE
,Region
,ReimbursementStatus
,VALUEUNITS
,WholesalerSubGroup
,WholesalerWholesaler
,WID
)
) piv
where not exists(
select *
from [Italy].[ALD_Province] a
WHERE
a.WholesalerWholesaler = piv.WholesalerWholesaler
and isnull(a.WholesalerSubGroup,'') = isnull(piv.WholesalerSubGroup,'')
and isnull(a.MarketCategory,'') = isnull(piv.MarketCategory,'')
and isnull(a.PackCategory,'') = isnull(piv.PackCategory,'')
and isnull(a.GenericStatus,'') = isnull(piv.GenericStatus,'')
and isnull(a.VALUEUNITS,'') = isnull(piv.VALUEUNITS,'')
and isnull(a.Region,'') = isnull(piv.Region,'')
and isnull(a.PERIOD,'') = isnull(piv.PERIOD,'')
and isnull(a.[RANGE],'') = isnull(piv.[RANGE],'')
and isnull(a.MICROBRICK,'') = isnull(piv.MICROBRICK,'')
and isnull(a.Province,'') = isnull(piv.Province,'')
and isnull(a.MICROBRICKSelected,'') = isnull(piv.MICROBRICKSelected,'')
and isnull(a.PrescriptionStatus,'') = isnull(piv.PrescriptionStatus,'')
and isnull(a.ReimbursementStatus,'') = isnull(piv.ReimbursementStatus,'')
and isnull(a.Manufacturer,'') = isnull(piv.Manufacturer,'')
and isnull(a.ProductType,'') = isnull(piv.ProductType,'')
and isnull(a.Product,'') = isnull(piv.Product,'')
AND TRY_CONVERT(UNIQUEIDENTIFIER, piv.WID) is not null
)
--)
SET @LoopCounter += 1
END
DROP TABLE #temp
DROP TABLE #tempUncachedReports
GO
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
DROP TABLE #temp
IF OBJECT_ID('tempdb..#tempUncachedReports') IS NOT NULL
DROP TABLE #tempUncachedReports
DECLARE @ReportPath varchar(max) = '/Italy/Strade_Province'
DECLARE @ReportDate datetime = dateadd(day,-1,getdate())
declare @ParameterName varchar(50)
declare @ParameterValue varchar(max)
declare @S varchar(max)
declare @R varchar(max)
declare @rw int
CREATE TABLE #tempUncachedReports
(
RowNo int
,ReportName varchar(1000)
,ParameterValue varchar(max)
)
CREATE TABLE #temp
(
ReportName varchar(1000)
,ParameterName varchar(1000)
,ParameterValue varchar(max)
,RowNo int
)
/*Insert uncached not in report*/
INSERT INTO #tempUncachedReports
SELECT rank() over(order by ItemPath,ParameterValues) as rowNo,ItemPath,ParameterValues
from (
select distinct ItemPath,replace(replace(replace(replace(replace(cast([Parameters] as nvarchar(max)),'&','#'),'%5B','['),'%5D',']'),'%26','&'),'%20',' ') as ParameterValues
from [ReportServer].dbo.ExecutionLog3
where Timestart >= @ReportDate
and ItemPath like @ReportPath
--and format = 'RPL'
and Source = 'Live'
) as a
DECLARE @LoopCounter int = 1
DECLARE @MaxVal int = (select max(RowNo) from #tempUncachedReports)
WHILE (@LoopCounter <=@MaxVal)
BEGIN
SET @R = (select ReportName from #tempUncachedReports where RowNo=@LoopCounter)
SET @S = (select ParameterValue from #tempUncachedReports where RowNo=@LoopCounter)
SET @rw = (select RowNo from #tempUncachedReports where RowNo=@LoopCounter)
while len(@S) > 0
begin
set @ParameterName = left(@S, charindex('=', @S+'=')-1)
set @ParameterValue = replace(left(@S, charindex('#', @S+'#')-1), @ParameterName + '=','')
set @S = stuff(@S, 1, charindex('#', @S+'#'), '')
insert into #temp
(
ReportName
,ParameterName
,ParameterValue
,RowNo
)
SELECT @R as ReportName,@ParameterName as ParameterName,@ParameterValue as Parameter,@rw as RowNo
end
SET @LoopCounter += 1
END
--select * from #temp
--select * from #tempUncachedReports
set @rw = (select max(RowNo) from #temp)
set @LoopCounter = 1
WHILE (@LoopCounter <=@MaxVal)
BEGIN
INSERT INTO [Italy].[ALD_Province]
([WholesalerWholesaler]
,[WholesalerSubGroup]
,[MarketCategory]
,[PackCategory]
,[GenericStatus]
,[VALUEUNITS]
,[Region]
,[PERIOD]
,[RANGE]
,[MICROBRICK]
,[Province]
,[MICROBRICKSelected]
,[PrescriptionStatus]
,[ReimbursementStatus]
,[Manufacturer]
,[ProductType]
,[Product]
,[ActiveFlag]
,[Ordering]
,[NewRow]
,[WID]
)
select distinct
WholesalerWholesaler
,WholesalerSubGroup
,MarketCategory
,PackCategory
,GenericStatus
,VALUEUNITS
,Region
,PERIOD
,[RANGE]
,MICROBRICK
,Province
,MICROBRICKSelected
,PrescriptionStatus
,ReimbursementStatus
,Manufacturer = null
,ProductType = null
,Product = null
,1 as ActiveFlag
,1 as Ordering
,1 as NewRow
,CONVERT(UNIQUEIDENTIFIER, WID) AS WID
from
(
select ParameterValue as value, ParameterName as columnname
from #temp
WHERE RowNo = @LoopCounter
) d
pivot
(
max(value)
for columnname in (
GenericStatus
,Manufacturer
,MarketCategory
,MICROBRICK
,MICROBRICKSelected
,PackCategory
,PERIOD
,PrescriptionStatus
,Product
,ProductType
,Province
,RANGE
,Region
,ReimbursementStatus
,VALUEUNITS
,WholesalerSubGroup
,WholesalerWholesaler
,WID
)
) piv
where not exists(
select *
from [Italy].[ALD_Province] a
WHERE
a.WholesalerWholesaler = piv.WholesalerWholesaler
and isnull(a.WholesalerSubGroup,'') = isnull(piv.WholesalerSubGroup,'')
and isnull(a.MarketCategory,'') = isnull(piv.MarketCategory,'')
and isnull(a.PackCategory,'') = isnull(piv.PackCategory,'')
and isnull(a.GenericStatus,'') = isnull(piv.GenericStatus,'')
and isnull(a.VALUEUNITS,'') = isnull(piv.VALUEUNITS,'')
and isnull(a.Region,'') = isnull(piv.Region,'')
and isnull(a.PERIOD,'') = isnull(piv.PERIOD,'')
and isnull(a.[RANGE],'') = isnull(piv.[RANGE],'')
and isnull(a.MICROBRICK,'') = isnull(piv.MICROBRICK,'')
and isnull(a.Province,'') = isnull(piv.Province,'')
and isnull(a.MICROBRICKSelected,'') = isnull(piv.MICROBRICKSelected,'')
and isnull(a.PrescriptionStatus,'') = isnull(piv.PrescriptionStatus,'')
and isnull(a.ReimbursementStatus,'') = isnull(piv.ReimbursementStatus,'')
and isnull(a.Manufacturer,'') = isnull(piv.Manufacturer,'')
and isnull(a.ProductType,'') = isnull(piv.ProductType,'')
and isnull(a.Product,'') = isnull(piv.Product,'')
AND TRY_CONVERT(UNIQUEIDENTIFIER, piv.WID) is not null
)
--)
SET @LoopCounter += 1
END
DROP TABLE #temp
DROP TABLE #tempUncachedReports
gET lIST CACHE SCRIPT 1
DECLARE @ReportPath varchar(max) = '/Italy/Strade_Province'
--DECLARE @ReportPath varchar(max) = '/Italy/Strade_Region'
DECLARE @ReportDate datetime = dateadd(day,-5,getdate())
declare @ParameterName varchar(50)
declare @ParameterValue varchar(max)
declare @S varchar(max)
declare @R varchar(max)
declare @rw int
CREATE TABLE #tempUncachedReports
(
RowNo int
,ReportName varchar(1000)
,ParameterValue varchar(max)
)
CREATE TABLE #temp
(
ReportName varchar(1000)
,ParameterName varchar(1000)
,ParameterValue varchar(max)
,RowNo int
)
/*Insert uncached not in report*/
INSERT INTO #tempUncachedReports
SELECT rank() over(order by ItemPath,ParameterValues) as rowNo,ItemPath,ParameterValues
from (
select distinct ItemPath,replace(replace(replace(replace(replace(cast([Parameters] as nvarchar(max)),'&','#'),'%5B','['),'%5D',']'),'%26','&'),'%20',' ') as ParameterValues
from dbo.ExecutionLog3
where Timestart >= @ReportDate
and ItemPath like @ReportPath
--and format = 'RPL'
and Source = 'Live'
) as a
DECLARE @LoopCounter int = 1
DECLARE @MaxVal int = (select max(RowNo) from #tempUncachedReports)
WHILE (@LoopCounter <=@MaxVal)
BEGIN
SET @R = (select ReportName from #tempUncachedReports where RowNo=@LoopCounter)
SET @S = (select ParameterValue from #tempUncachedReports where RowNo=@LoopCounter)
SET @rw = (select RowNo from #tempUncachedReports where RowNo=@LoopCounter)
while len(@S) > 0
begin
set @ParameterName = left(@S, charindex('=', @S+'=')-1)
set @ParameterValue = replace(left(@S, charindex('#', @S+'#')-1), @ParameterName + '=','')
set @S = stuff(@S, 1, charindex('#', @S+'#'), '')
insert into #temp
(
ReportName
,ParameterName
,ParameterValue
,RowNo
)
SELECT @R as ReportName,@ParameterName as ParameterName,@ParameterValue as Parameter,@rw as RowNo
end
SET @LoopCounter += 1
END
--Takes into account multiselect parameters
select Main.ReportName, Main.ParameterName, ParameterValue=replace(Left(Main.ParameterValue,Len(Main.ParameterValue)-1),'&','&'),RowNo
from
(
select distinct ReportName, ParameterName,RowNo,
replace(replace((
SELECT a1.ParameterValue + ',' as ParameterValue
from #temp a1
where a1.ReportName = a2.ReportName
and a1.ParameterName = a2.ParameterName
and a1.RowNo = a2.RowNo
ORDER BY a1.ParameterName
FOR XML Path('')
),'<ParameterValue>',''),'</ParameterValue>','') as ParameterValue
from #temp a2
) Main
order by RowNo,ParameterName
--Regular, no multiselect
--select * from #temp
DROP TABLE #temp
DROP TABLE #tempUncachedReports
--DECLARE @ReportPath varchar(max) = '/Italy/Strade_Region'
DECLARE @ReportDate datetime = dateadd(day,-5,getdate())
declare @ParameterName varchar(50)
declare @ParameterValue varchar(max)
declare @S varchar(max)
declare @R varchar(max)
declare @rw int
CREATE TABLE #tempUncachedReports
(
RowNo int
,ReportName varchar(1000)
,ParameterValue varchar(max)
)
CREATE TABLE #temp
(
ReportName varchar(1000)
,ParameterName varchar(1000)
,ParameterValue varchar(max)
,RowNo int
)
/*Insert uncached not in report*/
INSERT INTO #tempUncachedReports
SELECT rank() over(order by ItemPath,ParameterValues) as rowNo,ItemPath,ParameterValues
from (
select distinct ItemPath,replace(replace(replace(replace(replace(cast([Parameters] as nvarchar(max)),'&','#'),'%5B','['),'%5D',']'),'%26','&'),'%20',' ') as ParameterValues
from dbo.ExecutionLog3
where Timestart >= @ReportDate
and ItemPath like @ReportPath
--and format = 'RPL'
and Source = 'Live'
) as a
DECLARE @LoopCounter int = 1
DECLARE @MaxVal int = (select max(RowNo) from #tempUncachedReports)
WHILE (@LoopCounter <=@MaxVal)
BEGIN
SET @R = (select ReportName from #tempUncachedReports where RowNo=@LoopCounter)
SET @S = (select ParameterValue from #tempUncachedReports where RowNo=@LoopCounter)
SET @rw = (select RowNo from #tempUncachedReports where RowNo=@LoopCounter)
while len(@S) > 0
begin
set @ParameterName = left(@S, charindex('=', @S+'=')-1)
set @ParameterValue = replace(left(@S, charindex('#', @S+'#')-1), @ParameterName + '=','')
set @S = stuff(@S, 1, charindex('#', @S+'#'), '')
insert into #temp
(
ReportName
,ParameterName
,ParameterValue
,RowNo
)
SELECT @R as ReportName,@ParameterName as ParameterName,@ParameterValue as Parameter,@rw as RowNo
end
SET @LoopCounter += 1
END
--Takes into account multiselect parameters
select Main.ReportName, Main.ParameterName, ParameterValue=replace(Left(Main.ParameterValue,Len(Main.ParameterValue)-1),'&','&'),RowNo
from
(
select distinct ReportName, ParameterName,RowNo,
replace(replace((
SELECT a1.ParameterValue + ',' as ParameterValue
from #temp a1
where a1.ReportName = a2.ReportName
and a1.ParameterName = a2.ParameterName
and a1.RowNo = a2.RowNo
ORDER BY a1.ParameterName
FOR XML Path('')
),'<ParameterValue>',''),'</ParameterValue>','') as ParameterValue
from #temp a2
) Main
order by RowNo,ParameterName
--Regular, no multiselect
--select * from #temp
DROP TABLE #temp
DROP TABLE #tempUncachedReports
Deployment Guide
Version 1.0
Table of Contents
1
Document Control
1.1
About this document
|
Author
|
|
|
Distribution
|
BI Hosting Team
|
|
Published
|
02/01/2017
|
|
File Location
|
|
|
Status
|
Draft
|
|
Confidentiality
|
This document is confidential and must not be distributed
outside of IMS Health.
|
|
Copyright
|
© 2014 IMS Health Incorporated or its affiliates. All
rights reserved.
|
Changes made to this document
|
Version
|
Author
|
Date
|
Summary
|
|
1.0
|
Chaitanya Boorlagadda
|
02 Feb 2017
|
Document Created
|
1.2
Purpose of this document
This document describes the deployment
steps for the ALD Web application.
1.3
Audience for this document
BI Hosting team.
2
Server Configuration Steps
There are a number of steps required to deploy the
application.
2.1
Install following drivers
·
Microsoft ReportViewer 2010 Redistributabl
·
Microsoft SQL Server 2014 Analysis Management
Objects
2.2
Server Prerequisites
Each Web Application server requires the following:
·
.Net Framework Version 4.0
·
IIS 7.0 with standard Role Features enabled plus
the Management Service
2.3
Kerberos Configuration
·
SPN registration for the ALD URL to the ALD service
account
·
Delegations as follows:
o
Decision Center Service Account to ALD SPN
o
ALD Service Account to Decision Canter SPN
o
ALD Service Account to SSRS SPN
o
ALD Service Account to OLAP server SPN
o
TMG Server Account to ALD SPN
2.4
IIS Configuration
A Web Application needs to be created as follows:
·
In IIS Manager highlight the computername and
select ISAPI and CGI Restrictions
·
Set the ASP.NET
v4 entries to Allow
·
Create a new Application Pool with the following configuration:
o
Name: ALD
o
Classic pipeline mode
o
Service account relevant for that environment (passwords
from BI Hosting Infra Team)
o
.Net Framework version 4.0
·
Create a new empty folder at:
o
C:\inetpub\ALD
·
Create a new Web Application with the following
configuration:
o
Name ALD
o Physical
path: c:\inetpub\ALD
Use the Application pool created above
·
Authentication :
o
ASP.NET Impersonation and windows Authentication
should be enabled
3
Web Application Deployment
·
Checkout the code from Harvest and download locally.
Note that the files will all be read-only. Right click the root folder and
select Properties & take the
read only flag off.
·
Copy the code within the ALD folder from harvest
and paste it in below path:
o
C:\inetpub\ALD
·
Go to IIS and right click and tap on “Add
Application”.
·
Add Alias name as Project name (ALD) and give
the virtual path of the code location (ALD) in Physical Path and provide
External URL has host name based on environment and then click on ok. After
adding the application go to bindings and add another binding as internal URL
|
Environment
|
External URL
|
|
BU Dev
|
http://budev-ald.imsbi.rxcorp.com
|
|
UAT
|
https://uat-ald.imsbi.com
|
|
Sup
|
https://support-ald.imsbi.com
|
|
PROD
|
https://ald.imsbi.com
|
·
Click on Default document and move ‘defalut.aspx’
to top.
·
Go to ALD application folder in IIS, edit
web.config and do the following changes for every specific environment’s
o
Report server path and ReportFolder
(URL’s are listed in the next step, below
is the highlighted where the URL need to be changed
|
Environment
|
ReportServerPath
|
|
BU Dev
|
http://budev-auth.imsbi.rxcorp.com/_vti_bin/reportserver
|
|
UAT
|
http://uat-auth.imsbi.rxcorp.com/_vti_bin/reportserver
|
|
Sup
|
http://support-auth.imsbi.rxcorp.com/_vti_bin/reportserver
|
|
PROD
|
http://authoring.imsbi.rxcorp.com/_vti_bin/reportserver
|
o
In the path \inetpub\ALD\edit web.config in the connection
string based on the environment:
Change the Connection string based
on the environment to allow Web Service connecting to a OLAP Cube
|
Env
|
<ConnectionStrings>
|
|
BU Dev
|
<add
name="cubeSource" connectionString="Data Source=CDTSOLAP937D;Initial
Catalog=WHSVC_UK_M_IMS_1" />
|
|
UAT
|
<add
name="cubeSource" connectionString="Data
Source=CDTSOLAP556U;Initial Catalog= WHSVC_UK_M_IMS_1" />
|
|
Support
|
<add
name="cubeSource" connectionString="Data
Source=CDTSSQL187O;Initial Catalog= WHSVC_UK_M_IMS_1" />
|
|
PROD
|
<add
name="cubeSource" connectionString="Data Source=;Initial
Catalog= WHSVC_UK_M_IMS_1" />
|
o
SQLwrapperconfigdb changes, please contact BI
Hosting infra team for generating a SQL bd account and password and this
account details will not be shared to any ALD teams,
4
SSRS Deployment
4.1
Deploy SSRS Report in SharePoint[c1]
5
Report Subscription db configuration[c2]
steps
6
Appendix A – SSRS URLs
Use the following URLs for SSRS Deployment:
6.1
BU Dev
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.2
SIT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.3
UAT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.4
SIT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.5
SUPPORT
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
6.6
PROD
TargetDataSetFolder:
TargetDataSourceFolder:
TargetReportFolder:
TargetReportPartFolder:
TargetServerURL:
Subscribe to:
Posts (Atom)