locked
Questions about version, exporting and email notification RRS feed

  • Question

  • Hi,

    1. Can we delete a specific version for a model? If this is possible, how can I delete it?

    2. I've set up the hierarchy parent/child subscription view, but how do I export the derived hierarchy?

    3. I've published a business rule, and one element failed the validation. Also, I've set an user to be notified and the notification status is true. Theoretically, that user should've received a notification email, but nothing happened. Can someone explain?

    Thank you all.



    Tuesday, July 26, 2011 7:05 PM

Answers

  • Hi Syukis,

    You export via the SQL Server database, so the "back end" as you say. The subscription view will create a SQL Server view, and it's that view that you use to do any exporting that you want. So the SQL Server view will contain all the hierarchy data in the format you specify.

    The subscription views have nothing do with Excel I'm afraid. The "Export to Excel" button simply takes the contents of the grids that you see and exports that to Excel.

    Hope that helps

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    • Marked as answer by SyukiS Wednesday, July 27, 2011 6:54 PM
    Wednesday, July 27, 2011 6:48 PM
  • Hi,

    Deleteing versions is possible, but not in the front end:

    http://technet.microsoft.com/en-us/library/ff486955.aspx

    You can export hierarchies using subscription views:

    http://msdn.microsoft.com/en-us/library/ee633741.aspx

    As for not receiving the email, that could be for a number of reasons. First, check the user actually has an email address in User and Group permissions in the MDS front end. Second, check that emails have been configured correctly using the MDS configuration manager:

    http://technet.microsoft.com/en-us/library/ff486965.aspx

    If that doesn't address it, then the following link has a number of troubleshooting options:

    http://msdn.microsoft.com/en-us/library/ff486959.aspx

    HTH

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    • Marked as answer by SyukiS Wednesday, July 27, 2011 6:54 PM
    Tuesday, July 26, 2011 9:08 PM

All replies

  • Hi,

    Deleteing versions is possible, but not in the front end:

    http://technet.microsoft.com/en-us/library/ff486955.aspx

    You can export hierarchies using subscription views:

    http://msdn.microsoft.com/en-us/library/ee633741.aspx

    As for not receiving the email, that could be for a number of reasons. First, check the user actually has an email address in User and Group permissions in the MDS front end. Second, check that emails have been configured correctly using the MDS configuration manager:

    http://technet.microsoft.com/en-us/library/ff486965.aspx

    If that doesn't address it, then the following link has a number of troubleshooting options:

    http://msdn.microsoft.com/en-us/library/ff486959.aspx

    HTH

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    • Marked as answer by SyukiS Wednesday, July 27, 2011 6:54 PM
    Tuesday, July 26, 2011 9:08 PM
  • Hi Jeremy, thank you for your reply. I just have some follow-up questions.

    The page for exporting hierarchies doesn't really say how to export. All the tutorials I found so far only talk about how to set up subscription views, which I have already done. I still need to find out how to export. Do we export at the back end? If not, do you happen to know how to do that?

    Also, for the subscription views that we we set up, do they have anything to do with the "export to excel" function? Or are they actually for another export function?

    Wednesday, July 27, 2011 5:41 PM
  • Hi Syukis,

    You export via the SQL Server database, so the "back end" as you say. The subscription view will create a SQL Server view, and it's that view that you use to do any exporting that you want. So the SQL Server view will contain all the hierarchy data in the format you specify.

    The subscription views have nothing do with Excel I'm afraid. The "Export to Excel" button simply takes the contents of the grids that you see and exports that to Excel.

    Hope that helps

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    • Marked as answer by SyukiS Wednesday, July 27, 2011 6:54 PM
    Wednesday, July 27, 2011 6:48 PM
  • Do you happen to have a sample of what a hierarchy looks like when we export it? And what file format is it in? Excel? Pdf? Thanks. =D
    Thursday, July 28, 2011 1:44 PM
  • You can't actually export a hierarchy to Excel as far as I'm aware, you can only export the individual members that make up each level. Basically you can export any time you see the Explorer grid. You will see the Explorer Grid in when you click the "pencil" icon in Explorer and also when you're looking at a hierarchy and you click on an individual member.

    The format that it exports to is an Excel xlsx file.

    The format of a subscription view (sql server view) for a hiearchy can either be "Explicit Levels" or "Parent Child". That's defined by the Format option when you create the subscription view. Explicit Levels will create a de-normalised star schema style view, wheras parent child will create each member in the hierarchy with a pointer to it's parent

    HTH

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx If a post answers your question, please click the Mark As Answer button.
    Thursday, July 28, 2011 2:07 PM