RE: Time Dimension Customer Member dynamic definition of parent

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joerg (Joerg_at_discussions.microsoft.com)
Date: 06/24/04


Date: Thu, 24 Jun 2004 06:25:02 -0700

Hello Minas,
you can not in Analysis Manager.
But you can add "commands" via DSO.
you can set the default member in Analysis Manager
to the last completd month.

HTH
Jörg

"Minas Papageorgiou" wrote:

> I have created a calculated member for a time dimension that is set to the last complete month of sales data and named it Last Complete Month. I have not set a parent member to it.
> While it works properly, the functions such as YTD do not work. Is there a way to set the parent member dynamically with MDX?
> Thanks
> MP
>



Relevant Pages

  • Re: MDX Non Empty handling Empty String Value
    ... Thanks for the advice. ... Member in Analysis Manager and then just referenced the Calculated ... > Newsgroups: microsoft.public.sqlserver.olap ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated member with a calculated member parent
    ... it's impossible for Calculated Member to have its own children. ... > calculated members in the cube using Analysis Manager. ... > me to choose the CurrentYear member as the parent, yet the CurrentQuarter ...
    (microsoft.public.sqlserver.olap)
  • create dimension without member
    ... Analysis manager won?t let me create dimension unless fact table filed has ... value init. ... how do I create MT dimension(dimension without member) ...
    (microsoft.public.sqlserver.olap)
  • Re: Error procesing cube
    ... DSO) can get confused sometimes in its error handling and the number gets ... such as this "invalid rectangle" one. ... make sure you have specified a system-wide processing log file. ... Analysis Manager, right-click on the server name and select Properties, then ...
    (microsoft.public.sqlserver.olap)
  • Re: use DSO to Merge partition error when open with Analysisi Mananger
    ... Since it uses DSO, it locks out DSO operations as well. ... but I got error when this cube opened with Analysis Manager? ... > Microsoft China Development Centre ...
    (microsoft.public.sqlserver.olap)