Comentários (12)

1 Phil_Mair comentou às Link permanente

What use do people make of an exported annotations database? <div>&nbsp;</div> Is it possible to create a Framework Manager project that picks up the annotation tables and joins them correctly so that the annotations can be compiled in a useful form? I want to be able to compile the annotations of a number of users. What’s the best way of achieving this?

2 NickMann comentou às Link permanente

The intended use is deployment. Porting your annotations across systems and from one db type to another. If you export a report and have some annotations that you want to go with it, you must export the annotations as in the article. <br /> Having said that there have been several requests for an fm model that can me used to report off annotations, and an article on that topic is coming shortly. <br /> Nick

3 Phil_Mair comentou às Link permanente

Thanks. I'm getting some pressure from within my organisation to do this now. How do I find out how the tables will join and how do I get it to report on comments by person, object and intersection point (when a comment is made in a crosstab cell I want to be able to identify the row and column node).. or do I have to wait for the Framework Manager model?

4 NickMann comentou às Link permanente

Hi again... we've had a number of requests on this topic. I'm currently putting together a framework manager model and a sample report. Will post it when its available. <br /> Nick

5 Phil_Mair comentou às Link permanente

Thanks Nick. I look forward to the Framework Manager model. It will be a boon to a number of organisations I do work for. <br /> Phil

6 NickMann comentou às Link permanente

just to keep you updated, I've been unable to create a model that resolves the usernames and report names / paths from their stored contentIds. I'll publish the model I have here shortly.

7 Phil_Mair comentou às Link permanente

When do you think it'll be available?

8 NickMann comentou às Link permanente

Hi there <br /> I've posted a new entry with what I have <br /> <div>&nbsp;</div> As you will see I was unable to resolve content ids of user and parent report in the annotation report. <div>&nbsp;</div> Nick

9 Phil_Mair comentou às Link permanente

Thanks Nick. I was wondering if we could use the IBM Cognos 10 Audit Extension to make the link between the user ID ([ANN_ANNOTATION].[owner]) and the person's name? In addition, is there any way of identifying more information about the cell location of a comment in a crosstab? <br /> Phil

10 NickMann comentou às Link permanente

Yes that looks possible, although not sure how the report ids could be <br /> resolved using audit... probably possible though. I was looking at writing <br /> a simple sdk app that runs off a db trigger from a modelled stored <br /> procedure that pulled users and reports into a modelled table, then run <br /> that task right before the commentary report in an agent, but it was too <br /> much for the time I had! <br /> So thats when I thought that a patch to enhance the annotation store data <br /> is much simpler. <div>&nbsp;</div> The annotation store data does have the context information, it carries <br /> links to a Dimensions table which has links to a Metadata items table. I'll <br /> have a look at enhancing the model / report to include them if it owuld be <br /> useful to you? <div>&nbsp;</div> Nick

11 Phil_Mair comentou às Link permanente

Yes Nick, a model with the dimensional links would be fantastic. Alternatively you could just tell me the joins that people will need to achieve this. <br /> Phil <br />

12 NickMann comentou às Link permanente

@Phil (mairp) I have an updated model with the annotation table links added. I havnt produced any reports from it as yet so I dont want to publish it... would you care to take a look and we could chat offline about producing a sample report ?

Incluir um Comentário Incluir um Comentário

+Media center

Click to view Cognos videos and pictures