Hi,

Is it possible to synchronise the particular cube in a SSAS database?.I Dont want to synchronise the whole database, i am having 5 cubes in a database , i need...

Hi,

Thanks For ur replies..

Synchronise SSAS wizard Is used to synchronise the complete SSAS database. Here , 1st Test-server having cube named (Test-Model) which contains dimensions and fact tables. The...

ya.. Access denied to connect server....below mentioned error msg throwing..

ERROR MESSAGE:

A connection To the computer cannot be established . Access denied

Hi,

Thanks for ur reply..

I am able to design ssrs report in local system...while deploying , URL not found error is coming..... i tried lot of times

in my local system (

ya..I am completely new to sql server..Anyway thanks for ur useful information.. I will learn SQL As soon as possible..

select 1, 2 ,1, 1602D021A0830043 ,2010-06-01 00:00:44.000 ,2010-06-01 00:01:34.000, 9141741452 ,9141155155 ,Main Menu, 1 ,Product and promotion, 1

select 2 ,2 ,2, 1602D021A0830043, 2010-06-01 00:00:44.000, 2010-06-01 00:01:34.000, 9141741452 ,9141155155, 1 ,Product...

1211602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.00091417414529141155155Main Menu1Product and promotion1

2221602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551551Product and promotionMain Menu2Other Offer Details1

3231602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551552Other Offer Details1Product and promotion3Offer 31

4251602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551551Wrong Entry3Offer 31

5241602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551553Offer 32Other Offer Details1Wrong Entry1

6411602D021A08700432010-06-01...

select A.Period, A.CallerANI,A.CallerDNIS,A.MenuName, A.NextMenuName ,

(CASE WHEN A.NextMenuName = @PrimaryMenu THEN (ISNULL(B.inToCount,0)+F.Offered) ELSE ISNULL(B.inToCount,0) END) as inToCount,

ISNULL(C.OutToCount,0) as OutToCount,

(CASE WHEN A.MenuName = @PrimaryMenu THEN (ISNULL(D.inToCount,0)+F.Offered) ELSE ISNULL(D.inToCount,0) END) as...

Create Table IVRMENU_SPLIT1

(

ID int,

MainID int,

SplitID varchar(200),

streamID varchar(200),

OfferedTime datetime,

TerminatedTime datetime,

CallerANI varchar(200),

CallerDNIS varchar(200),

IVRDigit int,

MenuName varchar(220),

PrevIVRDigit int,

PrevMenuNAme varchar(200),

NextIVRDigit int,

NextMenuName varchar(200),

IVRDISCONNESTED int

)

Now this query running correctly. Check this and create the table. I...

Create Table IVRMENU_SPLIT

(

ID int,

main ID varchar(200),

SplitID varchar(200),

streamID varchar(200),

Offered Time datetime,

Terminated Time datetime,

CallerANI varchar(200),

...

ID main ID SplitIDstreamIDOffered TimeTerminated TimeCallerANICallerDNISIVR DigitMenuNamePrevIVR DigitPrevMenuNAmeNext IVR DigitNectMenNameIVR DISCONNESTED

1211602D021A083004300:44.01:34:0091417414529141155155Main Menu1Product and promotion1

2221602D021A083004300:44.001:34.0914174145291411551551Product and promotionMain Menu2Other Offer Details1

3231602D021A083004300:44.001:34.0914174145291411551552Other Offer Details1Product and promotion3Offer 31

4251602D021A083004300:44.001:34.0914174145291411551551Wrong Entry3Offer 31

5241602D021A083004300:44.001:34.0914174145291411551553Offer 32Other Offer Details1Wrong...

Check this SP Also:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

--

--ALTER PROCEDURE [dbo].[SSIS_IVRAnalysis_IVR_InsertMenusByTimesMobileNumberMenu]

--(

DECLARE

@LastID int,

@MaxID int

--)

--AS

set @LastID=0

----set @MaxID =20000

select @MaxID= Max(ID) from ivrmenu_split where year(terminatedtime)=2010...

SOURCE DATA:

COLUMN NAMES:ID ,STREAMID ,OFFEREDTIME ,TERMINATEDTIME ,Menuname,Prevmenuname,NextMenuName,ivrdisconnected,CallerANI,CallerDNI

200 , 160#A31 ,2010-06-01 01:29:59.000,2010-06-01 01:29:59.000,Account,Agent,Agent Transfer,13,9865,9678

221,160#B31,2010-06-01 02:29:59.000,2010-06-01 01:29:59.000,MenuName,Repeat Offer,Account,15,998,997

222,160#c#1,2010-06-01 03:29:59.000,2010-06-01 02:29:59.000,Previousmenu,Account,Agenttransfer,16,997,09

STORED PROCEDURE:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[SSIS_IVRAnalysis_IVR_InsertMenusByTimesMobileNumberMenu2]

(

--DECLARE ...

l

its k... send answer if you know.. i am new to this field... so only... dont use conditional split for this...