iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

  • Facebook
  • Instagram
  • LinkedIn
  • Phone
  • Twitter
  • YouTube

Copyright © 2025 · iT Synergy·

Months ordered alphabetically
Months ordered alphabetically avatar

February 18, 2011 By Juan Camilo Zapata Montúfar Leave a Comment

One issue related when browsing a cube using Performance Point is that when you drag the Month dimension the months are sorted alphabetically and not by month.

One resolution to this problem is via MDX on PerformancePoint :

The problem is that PerformancePoint cant distinguish that a month is really a month.A possible solution is modify the MDX related to the Analytic Grid.

PerformancePoint Generates this MDX by default:

SELECT
{ [Calendary].[Year].[Year].ALLMEMBERS } * { [Calendary].[Month Name].[Month Name].ALLMEMBERS }
ON COLUMNS,

NON EMPTY { [Country].[Country].[Country].ALLMEMBERS } * { [Business Unit].[Business Unit].[Business Unit].ALLMEMBERS }
ON ROWS

FROM [Cube]

WHERE ( [Measures].[Vl End Balance] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FONT_FLAGS, FORE_COLOR, BACK_COLOR

Solution:

You have to tell Perfomance Point the order of the Months manually:

SELECT
{ [Calendary].[Year].[Year].ALLMEMBERS }

replace with:

{ [Calendary].[Month Name].[Month Name].[January],[Calendary].[Month Name].[Month Name].[February],[Calendary].[Month Name].[Month Name].[March],[Calendary].[Month Name].[Month Name].[April],[Calendary].[Month Name].[Month Name].[May],[Calendary].[Month Name].[Month Name].[June],[Calendary].[Month Name].[Month Name].[July],[Calendary].[Month Name].[Month Name].[August],[Calendary].[Month Name].[Month Name].[September],[Calendary].[Month Name].[Month Name].[October],[Calendary].[Month Name].[Month Name].[November],[Calendary].[Month Name].[Month Name].[December] }

As you note I have to tell Performance Point directly the order of the months.

the final code looks like this:

Filed Under: Performance Point Tagged With: MDX, Performance Point, sort dates mdx, sort dates performance point, Sort Months MDX

Could not load file or assembly msmgdsrv error while checking MDX syntax on Analysis Services
Could not load file or assembly msmgdsrv error while checking MDX syntax on Analysis Services avatar

February 9, 2011 By Juan Camilo Zapata Montúfar Leave a Comment

When writing a MDX expression inside a role , i`ve encountered a problem when checking the syntax. When you  click on the check syntax button , an error window appears saying  it cannot  find the assembly msmgdsrv .

image

A workaround to this problem is to edit the Ssms.exe.config  file in Analysis Services .

You can find this file on the path

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

Make sure you edit this file as an Administrator.

Inside the file look for the line

<codeBase version=”9.0.0.0″ href=”msmgdsrv.dll”/>

and change the href value with the absolute path of the msmgdsrv.dll file , typically it can be found at

C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\10\msmgdsrv.dll

the file should look like this:

<configuration>
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>
<probing privatePath=”PublicAssemblies;PrivateAssemblies”/>
<dependentAssembly>
<assemblyIdentity name=”msmgdsrv” publicKeyToken=”89845dcd8080cc91″ />
<codeBase version=”9.0.0.0″ href=”C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\10\msmgdsrv.dll”/>
</dependentAssembly>
</assemblyBinding>
<legacyUnhandledExceptionPolicy enabled=”1″/>
<newComVTableLayout enabled=”true” />
<generatePublisherEvidence enabled=”false”/>
</runtime>
</configuration>

Try checking the MDX syntax , it should be successful.

image

Filed Under: BizTalk, Performance Point Tagged With: Analysis Services mdx, cannot find the assembly msmgdsrv, MDX, Months ordered alphabetically on mdx, Sort Months MDX, Ssms.exe.config

Team


Marco
Antonio Hernández

Jaime
Alonso Páez

Luis
Carlos Bernal

Ana
María Orozco

Juan
Camilo Zapata

Carlos
Alberto Rueda

Sonia
Elizabeth Soriano

Diana
Díaz Grijalba

Alexandra
Bravo Restrepo

Bernardo
Enrique Cardales

Juan
Alberto Vélez

Jhon
Jairo Rodriguez

Diana
Paola Padilla

Gustavo
Adolfo Echeverry

Yully
Arias Castillo

Carlos
Andrés Vélez

Brayan
Ruiz

Jesús
Javier Hernández

Alejandro
Garcia Forero

Natalia
Zartha Suárez

Josué
Leonardo Bohórquez

Oscar
Alberto Urrea

Odahir
Rolando Salcedo

Jimmy
Quejada Meneses

Juan
Mauricio García

Mario
Andrés Cortés

Eric
Yovanny Martinez

Carolina
Torres Rodríguez

Tag Cloud

.NET (9) 940px (1) Analysis Services mdx (1) An attempt was made to load a program with an incorrect format. (1) ASP.NET MVC (1) Azure (3) Backup (1) BAM (7) BAM API (1) BAMTraceException (2) BI (3) BizTalk (24) Business Intelligence (6) C# (2) caracteristicas de publicacion (2) Content Editor (3) ESB (15) ESB Toolkit (3) General (4) habilitar caracteristicas (3) indexes (2) Integration Services (2) Master Page (3) MDX (2) MSE (11) net.tcp (2) Office 365 (2) Oracle (2) Performance Point (2) Public Website (2) Receive Location (2) SDK (2) Servicio Web (2) Sharepoint 2010 (2) SharePoint 2013 (4) SharePoint Online (2) SOA (8) Soap Fault (2) Sort Months MDX (2) SQL Server (2) Visual (2) Visual Studio 2010 (2) WCF (19) Windows (3) Windows 8 (17)

Categories

  • .NET (33)
  • Analysis Services (1)
  • ASP.NET MVC (2)
  • Azure (7)
  • BAM (9)
  • BAM PrimaryImport (3)
  • BigData (1)
  • BizTalk (77)
  • BizTalk 2010 configurations (57)
  • BizTalk Application (60)
  • BizTalk Services (13)
  • Business Intelligence (4)
  • Cloud (3)
  • CMD (1)
  • CodeSmith – NetTiers (2)
  • CommandPrompt (1)
  • CRM OptionSet mapping component (1)
  • Desarrollo de software (6)
  • develop (6)
  • developers (3)
  • DropBox (1)
  • Dynamics (1)
  • Enterprise Architect (1)
  • Entity Framework (1)
  • Errores BizTalk (2)
  • ESB (27)
  • ETL (1)
  • Event Viewer (1)
  • Excel Services (1)
  • Foreach loop container (1)
  • General (4)
  • Gerencia de Proyectos (2)
  • Google (1)
  • Grouped Slices (1)
  • Human Talent (1)
  • IIS (4)
  • Integración (6)
  • Integration Services (3)
  • KingswaySoft (1)
  • Lync (1)
  • MSE (13)
  • Office 365 (2)
  • Oracle Data Adapter (2)
  • Performance Point (4)
  • Picklist (1)
  • Pivot Table (1)
  • Procesos (1)
  • Pruebas (1)
  • Public Website (2)
  • Reports (1)
  • SCRUM (1)
  • SDK (2)
  • SEO (1)
  • Servicios (2)
  • Sharepoint (9)
  • SharePoint 2010 (10)
  • SharePoint 2013 (4)
  • SharePoint Online (2)
  • SharpBox (1)
  • Shortcuts (1)
  • Sin categoría (1)
  • SOA (50)
  • SQL (5)
  • SQL Server (3)
  • SQL Server Management Studio (1)
  • SSIS (3)
  • SSL (1)
  • SSO (1)
  • Tracking Profile Editor (2)
  • Twitter (1)
  • Uncategorized (1)
  • Virtual Network (2)
  • Visual Studio 11 (1)
  • Visual Studio 2010 (2)
  • Visual Studio Online (1)
  • VMware (2)
  • WCF (24)
  • Web (1)
  • Web Api (1)
  • Windows (5)
  • Windows 8 (11)
  • Windows Azure (2)
  • Windows Live Write (1)
  • Windows Phone (7)
  • Windows Phone 8 (1)
  • Windows Scheduler (1)
  • windows8 (2)
  • WindowsRT (3)
  • WP7 SDK (1)

Manage

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org