Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [CLOSED] migrate saved AD reports from one environment to another?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] migrate saved AD reports from one environment to another?
 Login/Join
 
Guru
posted
Hi Team,

Here's another question that I suspect you won't generally approve of, but I need to ask it:

Can I migrate saved AD reports for a specific user from one environment to another? I know I'd have to do this at the database level, so this leads me to wonder what table(s) stores the saved reports and what do you think would happen if I backed up that table(s), restored a PMF snapshot and then restored that table(s)?

This is a one-time only deal, and I'm basically trying to save the day for one of my important users.

Cheers,

Joey

This message has been edited. Last edited by: Moogle,


-WebFOCUS 8.2.01 on Windows
 
Posts: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
Master
posted Hide Post
It's quite likely that such an export/import action of this table at the database level would leave your mart in an unstable state. Note that linkages between Owners and Content are based on internal keys, and the relationship between Dashboards and content also duplicates some of this logic, so reloading these tables would shift the internal keys (they autonumber on INCLUDE). That would mean you'd have to go in an re-establish all the linkages and that would be much more tedious than manually adding the content between your data marts.

In general it's a difficult call to have separate PMF data marts for dev/test/production. We generally recommend you use a single mart for all three and use scorecards to link and thus hide the metrics. To support that more widely in 5.3.1 we are enabling you to show/hide content by Scorecard, so you could set up a "in development" scorecard that would combine new metrics you're building with new content you're building and that would give you a good logical model for this. You could then use snapshots to sync up the marts, if you still wanted to have separate ones, and that would also work.

RP has some techniques that could help you, I'd say chat with him about this requirement as well. There might be a way to limit content by scorecard via a technique in advance of the new feature we created.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [CLOSED] migrate saved AD reports from one environment to another?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.