Report Package Not Updated

[joecog]

Hi All,

I very new to Cognos Report Studio and find out that for the [Period].[Period].[Day] hierarchy, the member list only show up to 20110606 and from 20110607 onwards there is no such date.

Any idea on how do I update the day in Report Studio?



Joe

[Arpitagrawal9]

These Member values would be directly coming from the DB,You can check the database first.

Also if this doesn't resolves Ur issue you can let me know

[joecog]

Hi Arpitagrawal9,

Allow me to ask a silly question...How to check which database it is link to ?

Joe

[Arpitagrawal9]

Hi Joe,

I you want to find which data base your Model is pointing to you can open the Model and check for the Data source in the framework manger.You can see the Properties and you will find the Catalog name of the Database it is pointing too.

Else If you have multiple data source you can directly go to the query subject,do a right click check the query generated for that query subject it can give the db name

Or if you want to see the DB to which a report is pointing you can create a report wherein  you can create a SQL query as Select @@Servername as Server and point this query to another query and create a data item form the SQL you created which will give u the server name

Can you please pass in more details of your issue,Feel free to email me at arpitagrawal9@yahoo.co.in in case you need any further assistance.
Hope this helps :)

[joecog]

Hi Arpit,

I can't find the Model for the database that I'm searching for.
How do I check the model that hold the report package?

I had an existing report showing data up to 20110606 only. From 20110607 onwards, no data was updated in the report. I check under [Period].[Period].[Day] hierarchy, the date until 20110606 as well.
I try using other report package and the transaction data is up to date, only this report package have this issue.
Try to figure out what is the cause of this? Why the report package stop getting data from database?

[Arpitagrawal9]

Can you please find the Model i.e the Framework manager model for the package.

else if you are not able to do it you can drag a SQL in the report query and do a Select * on your period lookup so you will be able to see the results

[joecog]

Hi Arpit,

I was able to find the mdc file that link to the report package and can open it under Transformer

Powercubes show one of the cube is the cube that I looking for.

Is this mdc file is the data source ?

Joe

[Arpitagrawal9]

Hi Joe,

So your report is based on the Cube,what you can do is you can republish the cube if u are aware there is data for that particular period in the database.

As this may be one of the possible reason that the cube might contain old data and is not updated.

So once u update the cube u will see the latest data on ur report.


Hope this helps 8)

[Arsenal]

Do other day level categories exist when you see the dimension's diagram viewer? (right click dimension and "Show Diagram")

If you see the other day level categories in the diagram viewer, then the level property for the Day level may been set to "Include when Needed" which means only those days (in your case, June 6th and 7th) which have associated fact quantities will show up in AS/RS

You can try changing the level property (right click the day level) to Always to fix this

If you do not see the day level categories,  then it sounds like the time dimension was manually created which means it would only have the categories that were present on the DB at the time of the cube build/category generation. In this case, you can try rebuilding the time dimension using the Date Wizard and regenerate the categories to see if the correct categories now show up. Warning - do not select the default start year of 1900 - you'll generate way too many categories

[joecog]

Hi Arpit and Arsenal,

When I try to do the steps as suggested, surprisingly, the latest data is updated before I do anything.

Scratching my head, what had happen that trigger the updates...

Any idea?

Joe

[Arpitagrawal9]

Did you change anything in the Model

[blom0344]

Arpitagrawal9,

You are aware that you can directly communicate through PM (private messages) through the forum itself? It is common sense not to display all your private data within the posts themselves. Remember, post contents is out in the open web ;)

[joecog]

Hi Arpit,

I didn't change anything to the Model but two days before I read your reply, I had deleted all the mdc and vcd file in the selected folder.
I'm not sure is this the reason why system starts updating normally?

Joe

[Arpitagrawal9]

I am also not sure why this is happening at your end because if your report is cube based you must update the cube to show the latest data

[joecog]

Hi Arpit,

I will post again if this problem recur.
Thanks for all your reply...


Joe