Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
yasminpriya
Ram
Gaurav Pal
christianasteves
 Post New Web Links

## More Related Resource Links

### Performance Problems with calculate member in a cube

Hi,  I'm having performance issue with calculated member (Running total) which is created on one dimension in the cube.  Cube is having three dimension Product Details(Product Model, Product Type) , Time(Year & Month) & Qty type(In Qty & Out qty). See below for details Dimtime Year (Values 2000 to 2020) Month DimProd Product No Product Type Product Group DimQty Type In Qty Out Qty Fact Table Product No Year Month Qty Type of Qty( In Qty or Out Qty ) My MDX query for calculated member is  CREATE MEMBER [Qty Type].[Qty Type].[All].[Total] as      SUM(NULL:[TimeDim].[Hierarchy].CurrentMember , ([Qty Type].[Qty Type].[In Qty], Measures.[Qty]) - ([Qty Type].[Qty Type].[Out Qty], Measures.[Qty])  The formula is --> Total = Previous Period Total Qty + Inqty - Out Qty   This works perfectly when i browse at higher level (Qty Type on Rows & Time On Columns),   but when  i browse the cube adding dimension Product Details( Product group or Product Type) to Drill-through the In Qty & Out Qty,  the query is running and after one hour also it's not finished. Can anyone help me to solve this or propose new structure to resolve this issue.

### where is Named Query and Calculation member stores?

which place named query and calculation which created in dimension  stores ? and what are the schema is by default when we create cubes?

### create a calculated member in a cube in SSAS

Hello   I’m trying to create a calculated member in a cube in SSAS and was hoping someone could help.   What I’m looking to do is count the number of occurrences of a value in a field.  I have Status field that contains New, Renewals and Enquiries and another field that contains a count, the problem I have and the reason for this query is the count is set to 0 for Enquiries.   The tSQL equivalent would be something like...   Select Date, Status , count(Status) From aTable Where Status = ‘ENQ’   And to summarise, what I’m looking to do would look something like the below   Date Status Count Commission Apr-10 NEW 1 100 May-10 NEW 1 100 May-10 REN 1 50 Apr-10 ENQ 0 0 May-10 ENQ 0 0 Jun-10 REN 1 50 May-10 NEW 1 100 Just looking at the ENQ by month. Date Count of ENQ     Apr-10 1     May-10 1     Jun-10 0       Any help gratefully received.

### How can I limit the number of parameter selections?

HI I'm wondering if I can limit the number of parameter selections. For excample, user must  select 2 years in YEAR dropdownlist. Many thanks.

### Drop DownList (Limit the number of rows)

Hi All, I have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.Please advise me on how to achieve this.Rg/-

### how to perform calculation and KPI in cube?

Hi ,

I have a sales cube in that i want to perform some calculation on sales column.

How to do that?

how  to perform calculation and KPI in cube?

Gaurav

### Named Set And Calculated Member within Analysis Services Cube project

Hi there.

I have got the mdx below (titled as MDX In QUERY SsMS) that works fine in SQL Management studio.

I am battling to include it in my Analysis Services project.

Following the logic in the mdx query, I have created the 3 named set and one calculated member (You will see them below), but with no luck.

Please any guidance will do, I desperatly need to include it in my cube

MDX In QUERY SsMS

with

//Get Weeks with sales
set
[WeeksWithSales] as '
{filter(
{[Product].[Product Hierarchy].[SKU DESCR]
*[FinancialDate].[FINANCIAL WEEK].[FINANCIAL WEEK]}
,([Measures].[SLS R]) >0)}
'

//the first week
set

set
[LastWeek] as
'
TAIL(
[FinancialDate].[FINANCIAL WEEK].[FINANCIAL WEEK],1
)'
member
[NumWeeks] as 'count([FirstWeek].item(0).item(1):[LastWeek].item(0))'

select
[NumWeeks] on 0
from
(select [Product].[Product Hierarchy].[SKU DESCR].&[BALL BRIDGESTONE 08 E7 +]&[1041597] on 0
from (select ([FinancialDate].[Financial Calendar].[FINANCIAL MONTH].&[FY2010_MONTH06].parent.parent) on 0
from [TPSMerch]))

### How to find the Sum of a definite number of elements in a hierarchy in a cube

Hi,

I guess my Query is pretty simple, but I am very new to MDX so having a problem in formulating the same. I need to find out the top 10 members in my hierarchy on basis of a measure and then need to sum all the others in the Hierarchy as "All Others". To explain it in a bit of detail, Suppose I have a Geography Hierarchy containing Cities A, B,C...till Z. Now I want the population (measure) of the top 10 cities and in the 11th position I want the sum of all the rest cities (which are not counted in the top 10) for two years say 2010 and 2009 and then want the absolute difference of that as well. The result set should look like,

2009

### Report Model--is there a limit on the number of rows?

Is there a limit on the number of rows that a report model will support? Our report model has tables that have millions of rows of data. When we regenerate the model it starting to take hours to regenerate. Is that expected? Is there a limit on the number of rows that can be used with a model?
Kim B.

### "WHERE" in Cube calculation

Hi Everyone, I am trying to put a where clause in the Cube calculation but not getting it to work.

Here is the actual calculation which works:

([DimTime].[TimeHierarchy].CurrentMember .Lag (1),[Measures].[Actual Hour])* 1.25

Now, I want to add a where clause to this calculation which looks something like this:

WHERE ([Company].[Department].CHILDREN - [Company].[Department] .&[Research)

### Limit number of characters in the view field

Hello,

I wonder if I can limit number of characters that are being displayed in the view.  For example, one of the columns sometimes has very long description.  I want people to see only 300 characters, and if they want to read more, they have to click on the link to go to details.

Is it possible?

Thank you.

### create calculation sas cube

how do write calcuation in ssas for caculated columns, here's syntax i have sql..

select (BIRTH_DT from dbo.HM_MEMBERSHIP

where (datediff(year,BIRTH_DT,GETDATE())) between  30  and 39

### What is the max limit for number of characters in multiline text in Sharepoint?

Hi,

In Sharepoint list, i have a column define as multiline text.  I want to know, what is the max character limit in multiline text, and how can I increase it to unlimited text?

Thanks any help.

Abhijit Sil

### Is there anz [OperationContract] number limit?

Hi,

I have a WCF I write in Visual Studio 2010 in c#. Everything worked fine till now. Now I add a new [OperationContract] but it does not work. I does not get a result. I started to debug the problem and found taht in my webservice in the "result" variable the result is there. However in my client there is nothing returned. Tried to debug and turned on the debugging but nothing found. Finally I tried to add a new very simple [OperationContract] which just return a string. Nothing... If I add new [OperationContract] to my code they won't return enything. In the return result; code snippet I found that the result virable is correct but nothing returning to the client while all my previously written [OperationContract] works just fine.

Is there any limitation how many [OperationContract] can I write to my WCF program? Is there anybody who found similar problem?

Thanks,

G

I'm not a development! I'm an infrastructure engineer! Please be patient on the development forums! :)

### The number of calls to the Changed event for a single update in the data exceeded the maximum limit.

Dear All,

We have hit the big limit of 16 change events per single update.  Is there any way to extend this to say 25, we are not using infinate loops or anything.

Alternatively, is it possible to disable some change events when values are updated?

Thanks

William Man

### Limit number of Users accessing the WebService

I am having WSE webservice and i want to limit the users accessing the webservice for example, at a time only 50 users can use that service.

The problem here is the users can vary. We cannot predictate the users. Means, we cannot give authendication for users.

### How to create a calculation in a list - Calculate the number of days between two dates

I have a calculated column in a list called Days Open. This column contains the number of days between today (Sysdate) and another column called the Effective Date. Therefore, if Sysdate is 11/16/2010 and the Effective Date is 10/14/2010, how do I calculate the number of days between the two dates?

I tried using this formula: =TEXT(Sysdate-[Effective Date],"h") and then I tried =INT(Sysdate-Effective Date) & TEXT(Sysdate-Effective Date, ":hh:mm")

Neither formula worked. I hope it is something real simple that I am missing here. Any help you can provide will be highly appreciated!

 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All