Recent content by akaka

Hi I know many companies have upgraded to microstrategy 8.0 . what procedure's and test plans are to be laid out when going through with a major upgrade for microtstrategy. I would be very helpful if somebody could provide me with a test plan they followed . Thanks AK

I have a metric like this Apply simple ("Case when #0=#1 then #2 else #3 end", Metric A, Prompt 1, metric B, Metric C) Metric B = (Metric 1-Metric 2)/ Metric 2 Metric C = (Metric 3-Metric 4 )/ Metric 4 Both metric B and c are created as smart metrics I Can successfully use these metrics in...

nothing particular Functionality something like teraminer random sample

nothing particular Functionality soemthing like teraminer random sample

Is there a was to display only a random sample of just say 100 rows from a result set of 10 milliom rows thanks Atul Kakade

hi I have been using two object prompt, one to select other prompts and another to filter their content. I have been able to use this succesfully in my report . One issue i am having is that the admintrator says that my prompts show up as waiting for user in the 'I server' log and clog up...

Hi want to create a report like MArket Week end date metric 1 metric 2 metric 3 Previous weeks Previous weeks are the days from weekend date - 7 to weekend date - 28 So can any body suggregt how to make this work as i have list of week end date as input thanks Ak

thats doesnt seem to work. the 'per basket' metrics are not being grouped on each ad block . Also since this is an existing project i cannot do much in terms of the schema objects thanks, AK

table P_AD_HST -UPC - ad Block -ad eff date Bskt_ut_hst (Aggregrate table for entire basket) - Basket ID (Store, Lane, Date, transaction number) - sales amount - sales qty - cost - discount bskt_p_upc hst -Basket ID (Store, Lane, Date, transaction number) - UPc - sales amount -...