Recent Posts

Pages: [1] 2 3 ... 10
1
Framework Manager / Re: Way to automate editing multiple query items?
« Last post by LostInTime on Today at 01:18:00 pm »
At the end of the day the model is just an XML file. If you're any good with xpath it should be possible to write a quick script with whatever language you want.

I would interested in accessing my model as an xml file, how would I be able to achieve this? I'm somewhat familiar with xpath and I'm sure I could figure any issues with it if they arose.

I know the model saves as a cpf file, and theres multiple xml files next to it. Do these files contain all the query items and query subjects? I have skimmed but was unable to find everything, I opened them in a text editor. Should I be using a different program?

EDIT: So wow I was able to change the description, I guess everything is there in model.xml. Had to use notepad++ instead of visual studio. Yeah going to have to play with this and learn some xpath which will be helpful. Its very disorganized but, this is a good starting point. Thanks for the suggestion
2
Framework Manager / Re: Way to automate editing multiple query items?
« Last post by LostInTime on Today at 01:15:33 pm »
Here are a couple links that might give you ideas:

https://www.ibm.com/developerworks/community/forums/atom/download/attachment_14197152_Bulk_Loading_Screen_Tips_into_Framework_.doc?nodeId=b8ca17f1-1b23-46cf-8ab9-2a2ed873393f

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_fm.10.2.1.doc/t_replaceobjectsinthemodel.html

Thank you, I had reviewed the links and the issues I came up with are:

Link 1: Editing a bunch of query items, say like 25, is difficult in one excel sheet since everything is "disorganized" and not all relevant data is in one column, it is all over the place. Guide said I should do one by one, but that seems counterproductive and resorts back to "manual labor"

Link: Would still have to edit the files individually, and it seems I can only add a description en masse e.g. the same string for them all. Each string is unique to each value. I'd have to manually re-enter a new one.

With that being said, maybe I am missing something/doing something wrong or perhaps there are other options I could try doing?
3
I have a report which is based on a join.
Query A - has data items related to Product
Query B - had data items related to a Contract
Query C is a join of Query A and Query B with following cardinality(using a primary key)
Each A has one and only one B, B has one or more A.

All the parameters are applied on the child queries i.e, queries A and B.
Query C has a filter to return records with Max End Date (Contract)

This logic works for majority of the situations except a few. The exception being

B has contracts which has a start date and end date. For certain products, the contracts expire every year. If the user runs the report for a Particular product number without using a date parameter, the result set is as expected i.e a record with a max end date (ex: end date = Mar 2019)
However, when the user runs the report for the same product number but with a date prompt for 2018, the report returns a record for the product which has a contract expiring in 2018. While technically true based on the data, the user is now requesting that the filter for max date should be applied first and then the parameter for the date value be passed so that result set is null.

I have tried to use except function but the result is not as expected.
4
Hi all

We recently moved from cognos 10.2.2 to cognos analytics 11 . In 10.2.2 , I was using this class to freeze columns of crosstab.
It was working fine in 10.2.2 , but stopped working in cognos analytics. I will appreciate your pointers for this issue. I do not want to use in built "freeze column headings" as it reduces height of columns in crosstab. Thanks
5
How do I get this Alert Studio? I am using 11.0.7. I tried setting this up in Event Studio, but it appears that is nothing more than a scheduled report. I only want it to trigger an Event(Email) when a certain threshold is met.
6
Event Studio / Re: Report Alert Window
« Last post by ggray on Today at 12:51:52 pm »
I am still confused on this alert deal. I would like to trigger an email based on a metric that I either build in Event studio or that is on an existing report, but I can find no where to do this. Do I need to install an alert studio or something? Using 11.0.7
7
Reporting / Re: Complex calculation for generating character string
« Last post by CognosPaul on Today at 12:37:14 pm »
What is your underlying database?

If you're looking at SQL Server, something like this should work:

https://stackoverflow.com/questions/1324063/generating-random-strings-with-t-sql
8
Reporting / Re: textbox prompt for showing top items
« Last post by CognosPaul on Today at 12:19:14 pm »
topCount should work fine in SSAS. There are a few possible reasons the report is running slow.

Are there any detail filters? Slicers? What are the expression behind [Item] and [Volumes Current+Last Month]? Can you describe where you're putting the item? What's nesting in it? What is it nested in?
9
Framework Manager / Re: Way to automate editing multiple query items?
« Last post by CognosPaul on Today at 12:14:26 pm »
At the end of the day the model is just an XML file. If you're any good with xpath it should be possible to write a quick script with whatever language you want.
10
Framework Manager / Re: Way to automate editing multiple query items?
« Last post by Lynn on Today at 12:09:46 pm »
Hey all,

Just had a quick question. I need to edit multiple query items and change their description. I am a bit of newbie to using this software, but google hasn't been helping too much. Is there a way to easily find query items, or perhaps edit them with a script? E.g. create a script to read a csv file, find the query item and auto write the description using the info provided in the CSV?  or perhaps an internal tool I should familiarize myself with?

Thank you for reading!

EDIT: When locating the query items, there is a proprieties file "attached" to the query item. Is there anyway even to export that to something like excel or a csv sheet where I could easily edit it with a programming language like python?

Here are a couple links that might give you ideas:

https://www.ibm.com/developerworks/community/forums/atom/download/attachment_14197152_Bulk_Loading_Screen_Tips_into_Framework_.doc?nodeId=b8ca17f1-1b23-46cf-8ab9-2a2ed873393f

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_fm.10.2.1.doc/t_replaceobjectsinthemodel.html
Pages: [1] 2 3 ... 10

       
Twittear