I have to create a new static measure for a requirement for which I already have the MDX query. My question is how do I write the query in the script view to make it a static measure.
Using the query below gives me an error.
Any suggestions as how to write the new measure?
SET [Last90Members] AS
MEMBER [Measures].[Cumulative Sums] AS
,[Measures].[Internet Sales Amount]
[Measures].[Internet Gross Profit]
View Complete Post
declare @site table
insert into @Site
select 100 union all
select 200 union all
declare @Ticket table
insert into @Ticket
select 10,100 union all
select 20,200 union all
select 30,100 union all
select 40,300 union all
select 50,200 union all
declare @FeedBack table
insert into @FeedBack
select 1,10,'10-21-2010 10:30:16.047','10-21-2010 20:23:00.000',NULL union all
select 2,20,'10-21-2010 11:30:16.047','10-21-2010 12:23:00.000',NULL union all
select 3,20,'10-21-2010 14:10:18.045',NULL,NULL union all
select 4,10,'10-21-2010 20:30:18.045',NULL,NULL union all
select 5,20,'10-21-2010 15:18.047',NULL,'10-21-2010 18:15.034' union all
select 6,10,'10-21-2010 22:16.047',NULL,'10-21-2010 23:15.034' union all
select 7,10,'10-21-2010 23:20.034','10-21-2010 23:22.035',NULL union all
select 8,10,'10-22-2010 01:02.002',NULL,'10-22-2010 02:03.004'
I have the query below and I am trying to use historical queries to retrieve the information, I have put something together but running the Original query and my new query does not bring back thesame results, but i think I may be doing something incorrectly.
I am trying to search only the documents created by a an author. Below is the code that i am trying to use for keyword query but i am not getting any results at all.
string strQuery = "contentclass:" + "STS_ListItem_DocumentLibrary" + "author:" + strQueryText
Can anyone help me out here please.
What are the options for handling file uploads to reduce the memory footprint? Is there a way to upload in chunks? Is there a way to stream upload directly to disk instead of loading entire file in server memory?
I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??
I want to display some stats in a listview contril. The table contains a record for every impression and for every click, and every record has a datetime field for the time and date of the impression of click. I want to be able to display how many impressions and clicks there were in a given day and hour, something like below:
Date Time Impressions Clicks8/20/2010 450 14 Midnight -1:00am 150 5&n