how can i set Aggregate Function property of a Measure to 'Max' at a particular level in the cube

can calculated cells be used to apply different formulas to get information from different level of the cube..

i mean is it possible that if i dnt want the valus to...

well actually i have no nulls in the member_name col as the member_name col is defined /resticted by not null condition..

could anyone plz guide me i have recieved no replies to my post lately.i would be very grateful..

hi,

i am using Execute SQL task to alter table...

if i use

alter table test add company_name varchar(8) ( select company_name from junk)

it does not give any problem but...

hi,

when i use the same process for populating a samll fact table it is successfull.is it possible that i get TNS packet writer error when i have a very large...

what i am actually doing is that i am using a task to transfer a table from oracle source to an sql DB.

My tables are in the oracle DB but...

could anyone plese help me out .i posted my problem but did not get proper help.i am in serious trouble.i would be very grateful if anyone is able to help...

i am using the other connection for connecting with oracle Db it works perfectly well when i use a package to load

dimensions but doesnt work when i use it...

SELECT

cast(convert(varchar, DATE_TIME, 101) as datetime) as DATE_TIME,

MAX(QUANTITY) AS MAX_QUANTITY,

MIN(QUANTITY) AS MIN_QUANTITY,

AVG(QUANTITY) AS AV_QUANTITY

FROM TRANSACTIONS

group by cast(convert(varchar, DATE_TIME, 101) as datetime)

the above given code does not work in...

hi all,

i am using the following code to transform date from a source column in the form '01-jan-03' into day,month,quarter,year

SELECT DATEPART(yyyy, INDEX_DAT) AS TheYear,

'Q'+CAST(DATEPART(qq, INDEX_DAT) as varchar) AS TheQuarter,

DATEPART(mm,...

can i have a sample code to split date into parts in oracle as i have tried doing it but it doesnt seem to work.i am new into using sql.so...

hi all,

can anyone tell me what is equivalent to

DATEPART function ORACLE.So that i can split the date column into date,week,quarter and year..

can anyone tell me what ADOMD is as i am new into using sql analysis services.

i need to know the whole process of connecting a cube to VB.Can anyone tell...