|
More site info...
SQL Server Analysis Services | Forum profile
|
|
Forum profile page for SQL Server Analysis Services on http://technet.microsoft.com.
This report page is the aggregated overview from a single forum: SQL Server Analysis Services, located on the Message Board at http://technet.microsoft.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL Server Analysis Services" on the Message Board at http://technet.microsoft.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL Server Analysis Services:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
94
|
723
|
2,256
|
|
Post:
|
169
|
1,382
|
4,464
|
|
|
SQL Server Analysis Services Posting activity graph:
|
Top authors during last week:
user's latest post:
openquery, dynamic sql, ssas...
Published (2008-11-28 03:32:00)
It's messy and you can easily get your quoting wrong, but this is the only way that I know of doing it with straight T-SQL. A SQLCLR function or a .Net stored proc in SSAS would be a couple of other approachs that might be worth looking at. http://geekswithblogs.net/darrengosbell - please mark correct answers
user's latest post:
how to set demension attribute...
Published (2008-11-28 03:50:00)
Use Custom set Create some sets in the cube in the same order how you want to display in the reports... Then use those custom set as parameter for the reports... If any doubts, let me know... Mahe
user's latest post:
Starting with SSAS - TechNet Forums
Published (2008-11-28 17:26:00)
".. Can anyone tell how can i pass parameters to SSAS .." - in what context do you wish to pass parameters? You can send a parametrized MDX query to an SSAS server, if that's what you mean. You will find links to technical info on SSAS (including blogs, books and paers) here: http://www.ssas-info.com/ - Deepak
user's latest post:
Named Set (Business Rule) -...
Published (2008-11-27 12:26:00)
Hi, I m using MDX in report Layout(DashBoard Designer),ver i cant use TRIM() as u said... And I cant modify in Cube,as i am not using one Dimnesion..Iam using Two dimensioins (with the help of a named Set( MDX) ) Pls let me knw if im not clear... Regards,
user's latest post:
Processadd Dimension - TechNet...
Published (2008-11-27 05:25:00)
We moved to a new blogging platform and I accidentally broke some links in my blog post. I've fixed that problem now. Please try again and you should be able to download the example XMLA. http://artisconsulting.com/Blog/GregGalloway
user's latest post:
transfer partitions between...
Published (2008-11-28 14:50:00)
Partitions cannot be transferred. The only options are: 1. Recreate the partitions and process them 2. Do a synchronization Thanks! Business Intelligence Consultant || please mark correct answers
user's latest post:
What is @ in MDX? - TechNet Forums
Published (2008-11-28 06:16:00)
It is a variable that is entered when you design MDX queries in reporting services(SSRS) and use parameters. HTH Thomas Ivarsson
user's latest post:
MDX query next to last week -...
Published (2008-11-28 19:50:00)
I changed the brackets around and it seems to be working now. Code Snippet SELECT {[Measures].[GROUP RESTORE Hr],[Measures].[Fact Problem Tickets Count]} ON 0, NON EMPTY [DIM PROBLEM TICKETS].[CATEGORY]. MEMBERS ON 1 FROM [NMC_Problem_Tickets] where ([DIM NMC Filtered].[NMC FILTERED].&[Ops], ([DIM PROBLEM TICKETS CALC].[WEEK]. ALLMEMBERS . Item ( [DIM PROBLEM TICKETS CALC].[WEEK]. ALLMEMBERS . Count - 2)) )
user's latest post:
Track Login Usage - TechNet Forums
Published (2008-11-28 16:00:00)
Is their a way i can track in SSAS the track on people who have logged in last number of day ? If they logged in what part of the cube have then been browsing? Thank you
|
|
|
|
Latest active threads on SQL Server Analysis Services::
Started 1 week, 1 day ago (2008-11-25 22:49:00)
by AZ Vick
I have been trying to get data about the next to last week in my cube and have tried it several ways. My problem is when I build the query it works, however the next time the cube is processed it seems to break. Do you see anythign wrong with this MDX? Or have any idea why this is happening. Code Snippet SELECT {[Measures].[GROUP RESTORE Hr],[Measures...
Started 1 week, 1 day ago (2008-11-25 23:00:00)
by AZ Vick
I needed the bellow calculated measure to show up as a Zero instead of a null if their was a Fact Problem Tickets Count. It seems to be working, but the guy making the reports says he has to convert the 0 to an integer to do math on it. Anyone know what I have to do to have the 0 come up as a numeric value? Code Snippet iif ( [Measures].[Fact ...
Started 6 days, 9 hours ago (2008-11-28 08:11:00)
by Viji.R
Hi, Can anyone tell how can i pass parameters to SSAS. and some explanation -> link how SSAS works actually.... To my understanding i fugure out that it stores the data in such a way where the front end or reporting services can query on it. and would like to know what is the scope of SSAS in datawarehouse. and how can we determine what should be done in ...
Started 1 week, 1 day ago (2008-11-26 10:50:00)
by Sarita Deherkar
Hi all, I have created a cube in SSAS. And Now I want to create reporrt using that cube. In report I have to create cascading parameters (Example: I have two parameter country and city. So If I select country then their respective Citys should come in City parameter ) So any one of you could you please let me know that How Can I create cacscading parameter? ...
Started 6 days, 1 hour ago (2008-11-28 16:08:00)
by Joanne1983
Hi everyone In my Risk Class Dimesnion, I have a member called [Product], and a member called [Type]. [Type] contains two attributes, "Main" and "Add On" , so [Product] contains all the Products for both "Add On" and "Main" Also, I have two measures. "Add on Sales" and " Net Sales" This means that Add on Products will be attributed to Add on Sales and Main Products will be ...
Started 6 days, 1 hour ago (2008-11-28 16:00:00)
by L.C
Is their a way i can track in SSAS the track on people who have logged in last number of day ? If they logged in what part of the cube have then been browsing? Thank you
Started 1 week, 1 day ago (2008-11-26 15:39:00)
by L.C
Is their a way i can control SSAS to limit to process number of attributes in a dimension. By default it process every thing together throwing many sql queries, one query for each attribute. i use Oracle and Teradata as my platform and the DBA do not like that because it slows down their control. I was wondering if their are some setting which could limit the number of process ...
Started 6 days, 2 hours ago (2008-11-28 14:56:00)
by Steffen Gipperich
Hallo everybody, I am looking for a MDX-Statement that retruns a table, in witch a sum for each row and Column is shown. My result should look like that: Year AccountGroupA AccountGrou p B RowSum 2004 15 23 38 2005 10 10...
Started 6 days, 3 hours ago (2008-11-28 14:10:00)
by fmatuszewski
Suppose we have two indentical cubes A and B on a different or the same database. Let say that we achived two identical cubes by synchronization. If I remove some partitions from A cube. Is it possible to restore, transfer partitions back from B to A cube ?
Started 6 days, 4 hours ago (2008-11-28 12:25:00)
by Girija Shankar (India)
What is the maximum number of levels that can exist in dimension hierarchy .... Regards.. Girija Shankar The information provided “AS IS” with no warranties, and confers no rights - Please Mark Answers.
|
|
Hot threads for last week on SQL Server Analysis Services::
Started 1 week ago (2008-11-27 14:49:00)
by RS_NEwbiiieeeeeeeeeee
Hi can anybody help me with this: I would like to get a list of names using mdx. ie if used in Adventure Works cube, I would like to get a full list of products ordered by name. (I dont want any measures in relation to it, jus a full list of names as in the cube).... how would i do this? an example would be great. many thanks...
Started 1 week, 1 day ago (2008-11-25 17:38:00)
by vanilla83
Hello everybody, I have a problem and I hope that somebody can help me. If I process a dimension I get this error very often: In German: Fehler im OLAP-Speichermodul: Ein doppelter Attributschlüssel wurde bei der Verarbeitung gefunden: Tabelle: dbo_dimTicketDetails_RMT, Spalte: Granted_x0020_number_x0020_sign_x0020_amount, Wert: 0. Das Attribut ist 'Granted ...
Started 6 days, 19 hours ago (2008-11-27 21:48:00)
by Yeshia
Im beginning to dive into OLAP cubes and I find something confusing. I was thinking that you had to take an OLTP database, then transform and create a brand new OLAP database with a star schema (or snowflake I guess) THEN, you can create cubes. But now Im starting to think that you use an OLTP database to create a cube, the cube being the OLAP database itself. Can anyone give me ...
Started 1 week, 1 day ago (2008-11-25 23:54:00)
by ddsu001
SELECT { [Date Dimension].[Month].[Month].ALLMEMBERS } ON COLUMNS, { [Measures].[TotalProcessingCost], [Measures].[AvgTotalProcessingCost] } * HIERARCHIZE( { [Date Dimension].[ Year].&[2007], [Date Dimension].[Year].&[2008] } ) ON ROWS FROM [Sample] *** date dimension has following [Date Dimension].[DateID]( key ) [Date Dimension].[Month] [Date Dimension].[...
Started 2 months, 1 week ago (2008-09-22 10:12:00)
by Bharthi
Heloo All.. I have created a Named Set (query-scoped, WITH SET 'MYSET' AS '{ ...}')which is working properly. I wanted it as a session-scoped(CREATE SET CUBE.[MYSET] AS '{...}' ). i have created a business rule and deployed in planning business Modeler. Now, It is not giving the correct values.. Any Idea?? Hope im clear wid the info..If reqd,please let ...
Started 1 week, 1 day ago (2008-11-25 22:49:00)
by AZ Vick
I have been trying to get data about the next to last week in my cube and have tried it several ways. My problem is when I build the query it works, however the next time the cube is processed it seems to break. Do you see anythign wrong with this MDX? Or have any idea why this is happening. Code Snippet SELECT {[Measures].[GROUP RESTORE Hr],[Measures...
Started 1 week ago (2008-11-27 10:09:00)
by Bharthi
Hello Alll, Is there any function in MDX as LTRIM() in SQL? If not, How can we remove spaces using MDX ?? Pleas help!!!!!
Started 1 week, 1 day ago (2008-11-25 23:00:00)
by AZ Vick
I needed the bellow calculated measure to show up as a Zero instead of a null if their was a Fact Problem Tickets Count. It seems to be working, but the guy making the reports says he has to convert the 0 to an integer to do math on it. Anyone know what I have to do to have the 0 come up as a numeric value? Code Snippet iif ( [Measures].[Fact ...
Started 1 week ago (2008-11-27 02:12:00)
by Tomo1026
Hi all, I have been developping a analysis cube. The cube has Item demension. There are 100 web and excel reports which includes Item column and now my client wants to see those reports in desending order with item code. Seems to me that only acsending order can be accepted in demension attribute settings. Does anyone have any solutions?... | |
Size: 2,678 bytes
