This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
the calculated member is below,is there any problem,or how can I improve the performance,it need 30seconds to load , which is too long.
CREATE DYNAMIC SET CURRENTCUBE.[AdjProducts] as
Intersect (
nonempty(exists([Product].[Product Id].[Product Id], [Product].[Adj Flag].&[Y] ), [Measures].[current_sales])
,nonempty( [Product].[Product Id].[Product Id], [Measures].[last_sales])
) ;
CREATE MEMBER CURRENTCUBE.[Measures].[product_sales] as
sum( [AdjProducts], sum( head(
Order(
EXISTS( {ParallelPeriod([Date].[calendar].[year]
,1
,strtomember('[Date].[calendar].&[' + cstr([Measures].[start_date]) + ']'))
:ParallelPeriod([Date].[calendar].[year]
,1
,strtomember('[Date].[calendar].&[' + cstr([Measures].[start_date]) + ']')).lag(-120) }
,
,"Product_sales"
)
,[Measures].[datekey_sum]
, basc
)
, measures.days
)
,[sales] )) ,
NON_EMPTY_BEHAVIOR = { [sales] },
FORMAT_STRING = "#,##0.00;-#,##0.00", VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Product_sales';
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
You're posting your question to an English forum. Those nice characters not only hide the meaning of objects they denote, but, more importantly, hinder understanding of which are the same and which are different throughout the text. Do consider replacing them with English equivalents or at least Latin characters.
thanks for you reminding,I have modified.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
You can download an Analysis Services Performance Guide to find the appropriate optimization method for the part you want to optimize.details.aspx
Based on the Chinese characters that appear in your question, I guess you may understand Chinese, and you can also refer to the optimization method in this link.6479539.html
Best regards,
Percy Tang
----------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.