<appSettings>
<!--SSAS Connection string-->
<!--add key="SSASConnection" value="Provider=MSOLAP;Data Source=CDTSOLAP937D.gemini.dev;Initial Catalog=WHSVC_IT_M_IMS_1;Roles=PHOENIX"/-->
<add key="SSASConnection" value="Provider=MSOLAP;Data Source=xxx;Initial Catalog=WHSVC_IT_M_IMS_1;Roles=PHOENIX"/>
<!--Report Default Details-->
<add key="ReportGroup" value="ITALYALD"/>
<add key="ReportDefaultName" value="Strade_Region"/>
<!--Report Server Details-->
<add key="ReportServerPath" value="http://report/_vti_bin/reportserver"/>
<add key="ReportFolder" value="?http://report/SSRS/Italy/IAM/"/>
<add key="ReportExtension" value=".rdl"/><!--If SharePoint integrated use .rdl else blank-->
<!--Show Reporting Toolbars-->
<add key="ReportShowToolbar" value="No"/>
<add key="ReportShowParameterToolbar" value="No"/>
<!--iframe size (e.g. 100%/1400px or "" for full screen) [common: 1200px / 1400px]-->
<add key="iFrameWidth" value="100%"/>
<add key="iFrameHeight" value="1400px"/>
<!--Debug settings (Show errors, etc at top of screen)-->
<add key="DebugShowErrors" value="Yes"/>
<add key="DebugShowParameters" value="No"/>
<add key="DebugShowUser" value="No"/>
<!--Wholesaler query to get the default wholesaler of user logged in-->
<add key="WholesalerQuery" value="WITH MEMBER [Measures].[ParameterCaption] AS [WHOLESALER].[Wholesaler].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [WHOLESALER].[Wholesaler].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [WHOLESALER].[Wholesaler].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,[Wholesaler].[Wholesaler].DefaultMember ON ROWS FROM [WHS SALES]"/>
<add key="WholesalerParameter" value="WID"/>
<add key="ManuafacturerParameter" value="M"/>
<add key="ProductTypeParameter" value="PT"/>
<add key="ProductParameter" value="P"/>
</appSettings>
<connectionStrings>
<!--Wrapper connection-->
<!--add name="SQLWrapperConfigDB" connectionString="Data Source=cdtssql2027d.gemini.dev;Initial Catalog=WebWrapperConfig;UID=WebConfigWrapper;Password=!@#456@1(" providerName="System.Data.SqlClient"/-->
<add name="SQLWrapperConfigDB" connectionString="Data Source=xxx;Initial Catalog=WebWrapperConfig;UID=user;Passwordxxx" providerName="System.Data.SqlClient"/>
</connectionStrings>
No comments:
Post a Comment