Viewing 15 posts - 256 through 270 (of 340 total)
You will want to take a look at the Analysis Stored Procedure project on CodePlex for SSAS 2005 with the XmlaDiscover
http://www.codeplex.com/ASStoredProcedures
or in SSAS 2008 you can access the DMVs now...
January 2, 2009 at 5:55 am
You might want to take a look at some postings in the Microsoft forums in regards to this being related to a mismatched dll issue:
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/773988a0-1767-47ed-9405-77430e7db37f/[/url]
and
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/1e177adf-683d-478c-84fa-717879ba947d/[/url]
January 2, 2009 at 5:23 am
You could Sort the members based on the name of the attribute if needed using the Sort function in your query. If it is a physical member or you...
December 29, 2008 at 12:17 pm
Don't believe there is anything officially posted and available. I found another recent posting in the MSDN forums - Migrating Cognos 8 to Reporting Services[/url]. Sounds like you...
December 29, 2008 at 5:36 am
That is just the area to design the query, not execute the statement and view the results. Kind of odd that you are not able to do that like...
December 26, 2008 at 10:17 am
I have used CamStudio which is free and have uploaded videos to YouTube and also SoapBox and they have all turned out good. There is also the one from...
December 26, 2008 at 10:09 am
You can simply pass the parameters to the report through the URL and display the results in a web browser control.
December 26, 2008 at 6:11 am
Sorry, I am really not understanding the logic and what you are trying to do. Very difficult to understand what you are trying to accomplish. I thought you...
December 25, 2008 at 5:53 am
You can add custom members and aggregations that do no exist in the cube on the fly or in the calculations tab of the SSAS cube designer.
So for your date...
December 25, 2008 at 5:32 am
Looks like you might just have some aggregations going on that could be part of the hierarchy or some custom members that you can create and reference in the cube...
December 24, 2008 at 1:55 pm
Kind of confused by the posting with importing data from text file and then getting data from cube in Excel. What are you doing exactly?
With Excel 2003 you are...
December 24, 2008 at 1:41 pm
What tool are you using to display the values? Are you using Excel, SSAS, SSRS, something else? Within SSAS you can define this logic and you can then...
December 24, 2008 at 6:05 am
SCD2 is used as a means to be able to report on historical changes within the data warehouse over time. This would allow you to be able to track...
December 24, 2008 at 5:41 am
What front-end tool are you using where you need to be able to create the custom ranges? Are you providing the end-users a way to select the dates or...
December 24, 2008 at 5:32 am
I know there was a white paper and web cast for Crystal to SSRS, have not seen or heard of one for Cognos. It sounds like William Pearson III...
December 23, 2008 at 5:21 am
Viewing 15 posts - 256 through 270 (of 340 total)