Current Tags: faqremove tag


TitleAuthorSectionDate
How do I impersonate another user to test the MDX query in SSMS?MicrosoftArticles13/4/2011
Q: How to setup SSAS anonymous authentication - to access data from internet or another domain?Vidas MatelisFAQ1/2/2011
Q: Why on SSAS 2005 after restoring database backup I am getting corruption error?Vidas MatelisFAQ23/9/2010
SSAS FAQ by MicrosoftMicrosoftFAQ29/6/2010
Q: Why SQL function: ObjIDUpdate() takes long time to execute when ROLAP SSAS cubes are used?Akshai MirchandaniFAQ29/4/2010
Q: When I am browsing Real-time ROLAP cube, I am getting error message: OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.Vidas MatelisFAQ13/3/2010
Q: I have measure in my cube that shows duration on some event in seconds. How can I convert numeric result to string in the format hh:mm:ss?Vidas MatelisFAQ10/3/2010
Q: Can I control how CPU resources are assigned to Analysis Services service?webadminFAQ3/2/2010
Q: How in MDX can I override formating for all calculated measures in one measure group?Vidas MatelisFAQ3/12/2009
SSAS error during deployment - "The connection either timed out or was lost"Vidas MatelisFAQ6/10/2009
Q: In SSAS 2008 I am getting an error message when generating usage based aggregations: "Internal error: The parameter is not valid."Vidas MatelisFAQ8/6/2009
Q: How can I create a new Analysis Services project from existing SSAS database?Vidas MatelisFAQ26/5/2009
Q: How can I identify version/build of Microsoft SSAS 2005/2008 on my server?Vidas MatelisFAQ5/5/2009
Analysis Services 2008 $SYSTEM.DBSCHEMA_% DMVsVidas MatelisFAQ26/1/2009
Analysis Services 2008 $SYSTEM.DMSCHEMA_% DMVsVidas MatelisFAQ26/1/2009
Analysis Services 2008 $SYSTEM.MDSCHEMA_% DMVs Vidas MatelisFAQ26/1/2009
Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?Vidas MatelisFAQ26/1/2009
Q: How can I get a list of measures in one measure group from SSAS DMVs?Vidas MatelisFAQ21/1/2009
Q: How in DMV can I convert data_type field from integer to string representation?Vidas MatelisFAQ20/1/2009
Q: How can I get a list of available SSAS databases using DMVs?Vidas MatelisFAQ20/1/2009
Q: Which string functions can be used in the queries on SSAS DMVs?Vidas MatelisFAQ8/12/2008
Q: How to fix error "Error loading metadata: Parser: The end of the input was reached."Vidas MatelisFAQ2/12/2008
Q: How can I start Analysis Services service from the command line?Vidas MatelisFAQ26/11/2008
Q: Can I migrate Analysis Service 2000 database to Analysis Services 2008?Vidas MatelisFAQ3/11/2008
How to calculate YTD monthly average and compare it over several years for the same selected monthThomas IvarssonFAQ14/7/2008
Analysis Services 2008 $SYSTEM.DISCOVER_% DMVsVidas MatelisFAQ23/6/2008
MDX query for the count of customers for whom the earliest sale in the selected time period (2002 and 2003) occurred in a particular Product CategoryDeepak PuriFAQ12/6/2008
How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?Thomas IvarssonFAQ30/5/2008
How do I create a Rolling 12 Months Accumulated Sum that can show a trend without seasonal variationsThomas IvarssonFAQ30/5/2008
How do I group dimension members dynamically in MDX?Thomas IvarssonFAQ29/5/2008
How do I check for the top level in a dimension to avoid division by an nonexsting parent(-1.#INF)Thomas IvarssonFAQ26/5/2008
How do I check for division by zero and null to avoid -1.#INF in cellsThomas IvarssonFAQ26/5/2008
How to fix dimension processing error 'mdprocessdim.cpp line 3429 function MDProcessPropertyJob'Vidas MatelisFAQ9/5/2008
In an MDX query how can I get the top 3 sales years based on the order quantity?Vidas MatelisFAQ4/4/2008
How in the report can I order date dimension members in descending order?Vidas MatelisFAQ4/4/2008
How to find slice values that Analysis Services assigned to the partition dimensions?Vidas MatelisFAQ4/2/2008
MDX-When I process cube, I can see that data is loaded, but when I query data, all measures are emptyVidas MatelisFAQ6/12/2007
Why domain user group name is not found when creating Analysis Services security roleVidas MatelisFAQ6/12/2007
When accessing calculation tab in BIDS I am getting error Unexpected error occurredVidas MatelisFAQ5/12/2007
How to fix Analysis Services deployment error No mapping between account names and security IDs was doneVidas MatelisFAQ5/12/2007
How to use parameters with SSRS 2005 against a 2000 Analysis services CubeVidas MatelisFAQ27/9/2007
How do you test Analysis Services 2005 role settings impact on browsing / querying behavior?Vidas MatelisFAQ11/9/2007
How do you set Analysis Services 2005 drillthrough security on the cube?Vidas MatelisFAQ11/9/2007
MDX-How can I change currency symbol based on selected currency dimension memberVidas MatelisFAQ6/9/2007
How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and projectVidas MatelisFAQ5/9/2007
Can I create Reporting Services report based on MDX that lookups data from relational databaseMogen NielsenFAQ2/7/2007
I cannot start Analysis Services 2005 SP2 on Vista PC. Error - The service cannot be started...Vidas MatelisFAQ25/6/2007
How do I move Analysis Services 2005/2008 databases to a different folderVidas MatelisFAQ18/6/2007
How can I hide dimension attributes/hierarchy in one cube, but leave them visible in otherVidas MatelisFAQ13/6/2007
MDX-How can I get attribute key with MDXRamunas BalukonisFAQ11/6/2007

Item limit of 50 reached.
 

Pyramid Analytics