No announcements
Found 3884304 threads
-
0 VotesAnalysis services query logging with mdx
Hello, The default "query log" logs the execution statistics and the involved dimension stored in column "Dataset"; see also TechNet ...Answered | 2 Replies | 1011 Views | Created by SSISQ - Friday, August 2, 2013 4:04 PM | Last reply by SSISQ - Monday, August 5, 2013 3:00 PM
-
0 Votes
MDX Query using Bids
Hi, Apart from tracing (see http://msdn.microsoft.com/en-us/library/ms174946.aspx), I am not aware of any way to see the MDX used by OWC which is teh ...Answered | 2 Replies | 4648 Views | Created by Pravin.c - Tuesday, November 10, 2009 5:09 PM | Last reply by Pravin.c - Tuesday, November 10, 2009 9:03 PM -
0 Votes
Parameters and MDX queries with drillthrough
The first part of this (showing the list of documents) seems to require a drillthrough clause in a hand crafter MDX query.Answered | 1 Replies | 4552 Views | Created by Christopher J de C Marshall - Thursday, April 21, 2011 1:49 PM | Last reply by Javier Guillen - Thursday, April 21, 2011 6:00 PM -
0 Votes
MDX Query
Hi Mahesh, You need to create an ADOMD connection to conect to a cube and then using that connection you can write an MDX query (like we use an ...Answered | 4 Replies | 4709 Views | Created by XLP - Main - Tuesday, December 21, 2010 6:43 AM | Last reply by XLP - Main - Wednesday, December 22, 2010 1:51 PM -
0 Votes
mdx query
What is the MDX that you ran in Management studio?Answered | 1 Replies | 4266 Views | Created by paulixml - Tuesday, November 3, 2009 4:41 AM | Last reply by AshokDugaputi - Tuesday, November 3, 2009 5:19 AM -
2 Votes
changing mdx queries
I am not quite sure what the problem is but it seems that you recreate the whole table once you add a new column to your MDX query that pulls data into your Power Pivot model?Answered | 3 Replies | 630 Views | Created by JeffreyShumaker - Wednesday, November 27, 2013 5:23 AM | Last reply by Gerhard Brueckl - Thursday, January 2, 2014 11:12 AM -
0 Votes
Build mdx queries programatically
For example, when a user creates a pivot table in excel (connected to a cube), everytime they drag/drop dimension attributes and hierarchies on rows/columns and measures in ...Answered | 1 Replies | 463 Views | Created by bishnupatro21 - Monday, July 1, 2013 11:35 AM | Last reply by BillAnton - Monday, July 1, 2013 11:54 AM -
0 Votes
MDX query returns error
Thanks Charlie & Praj, My MDX is obviously a little rusty.Answered | 3 Replies | 214 Views | Created by JohnZofo - Monday, August 25, 2014 3:48 PM | Last reply by JohnZofo - Tuesday, August 26, 2014 2:48 PM -
0 Votes
MDX query cube usage analysis
you can use SQL Server Profiler to get the queries.Answered | 1 Replies | 895 Views | Created by Ludis - Friday, August 9, 2013 6:57 PM | Last reply by Butmah - Saturday, August 10, 2013 4:49 AM -
0 Votes
Not able to logging MDX Query using httpmodule
which authentication you are using in iis?Unanswered | 1 Replies | 91 Views | Created by An0nym0u5User - Monday, September 2, 2019 8:11 AM | Last reply by An0nym0u5User - Tuesday, September 3, 2019 3:14 AM -
0 Votes
Not able to logging MDX Query using httpmodule
which authentication you are using in iis?Unanswered | 1 Replies | 128 Views | Created by An0nym0u5User - Monday, September 2, 2019 8:11 AM | Last reply by An0nym0u5User - Tuesday, September 3, 2019 3:14 AM -
0 Votes
mdx query
Clients.Value,”DataSet1”) For more information, please see: Count function: ...Answered | 2 Replies | 2158 Views | Created by ermal1981 - Wednesday, April 11, 2012 3:29 PM | Last reply by Elvis Long - Friday, April 13, 2012 6:44 AM -
1 Votes
MDX query on Tabular Model
It's not the intention of an OLAP system to query details from fact tables; for this in common a OLTP / DWH = Data Warehouse is used.Answered | 4 Replies | 590 Views | Created by SGMSSharePoint - Friday, February 7, 2014 7:23 AM | Last reply by SGMSSharePoint - Friday, February 7, 2014 8:33 AM -
0 Votes
MDX Query
I would suggest posting your question in one of the Microsoft Newsgroups located here:Answered | 1 Replies | 7555 Views | Created by SathishKrishna - Saturday, December 6, 2008 8:15 AM | Last reply by Vijay Mullick - Monday, December 8, 2008 5:00 AM -
0 Votes
Need help in MDX Query
If this is the case you can retrieve the same month in the previous year by using ParallelPeriod (http://technet.microsoft.com/en-us/library/ms145500.aspx).Answered | 3 Replies | 3354 Views | Created by White1727 - Monday, June 21, 2010 5:16 AM | Last reply by Leo Schelvis - Monday, June 21, 2010 11:11 AM -
0 Votes
MDX Query
Hi Manisha, I am not sure what is your actual requirement, but if you just need to find currency for projects you can use following code - SELECT ...Answered | 1 Replies | 1900 Views | Created by Manisha_G - Monday, September 26, 2011 7:12 AM | Last reply by Santosh Kumar Joshi - Monday, September 26, 2011 7:21 AM -
0 Votes
Roles in MDX queries
Is there an easier way to do this in an MDX query?Answered | 4 Replies | 2170 Views | Created by DaveDB - Monday, April 2, 2012 3:08 PM | Last reply by Raunak J - Tuesday, April 3, 2012 6:30 AM -
0 Votes
mdx query
Hi, You can run MDX query like this: select {[Measures].Answered | 2 Replies | 4860 Views | Created by shiva.reddy - Wednesday, April 7, 2010 4:30 AM | Last reply by Raymond-Lee - Friday, April 9, 2010 3:54 AM -
1 Votes
MDX query
Hello, I think you should ask in theAnswered | 1 Replies | 411 Views | Created by Madhu ML - Wednesday, January 22, 2014 3:07 PM | Last reply by Just Karl - Wednesday, January 22, 2014 10:42 PM -
1 Votes
MDX Queries and Expressions
MDX expressions have to be executed in the context of a query.Answered | 2 Replies | 2254 Views | Created by markycalvert - Wednesday, January 25, 2012 7:27 AM | Last reply by Darren Gosbell - Friday, January 27, 2012 1:06 AM - Items 1 to 20 of 3884304 Next ›
No announcements
