Thanks for the reply.

Looks like it is available in Essbase to create Parent child measure.

We want to migrate from Essbase to MSBI. So, We need to achieve this functionality.

I have a fact table with below columns

FactID

Date

Location

Measure A

Measure B

Measure C

Measure D

And now I want to create calculated measure and that looks like

Measure S

Measure A

Measure B

Measure C

Measure D

that is Measure...

Hi,

You just modify the SP like below and it should work.

CREATE PROCEDURE spNewEmployee

@FirstName varchar(50),

@LastName varchar(50),

@skills SkillsTableType READONLY

AS

BEGIN

DECLARE @EmployeeID int

INSERT INTO Employees

(FirstName, LastName)

VALUES

(@FirstName, @LastName)

SET @EmployeeID =...

Use GETUTCDATE() which is available in SQL Serevr , it will convert your timezone into GMT .

Thats very cool and the simplest way..... Thanks a lot mate.. You made my job into nothing 🙂

Sorry.. It was typo...

this sp is helping me in development area in debugging the scripts to see the data of a table on the spot. 🙂

You might get this error

"is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

this is because you can select...

Hi,

this sp is helping me in development area in debugging the scripts to check the record count of a table on the spot. 🙂

Thanks for all of your reply 🙂

Yes. I tried to get the schema name for the table i pass and if there are more than one schema available(not many table...

any help on this??? 🙁

Hi,

Thanks for the reply.

Yes. the SP is working if we put single quotes across the tablename ('schemaname.tablename').

I want to try whether is it...

in column level constraint is it possible??

and in which case we will have column level constraints

Thanks & regards

G.S.K