Recent Posts

Pages: 1 2 [3] 4 5 ... 10
21
Cognos Administration / Re: Unable to backup entire content store
« Last post by Diaonic on 18 Oct 2018 08:53:38 am »
MF

Thanks for the reply. So the deployment folder does exist inside of the Cognos folder:
F:\Program Files\IBM\cognos\c10_64\deployment


Inside cognos configuration I see this:
https://imgur.com/a/xjxcMlO

When I do an export and choose select folders, then manually select all of the reporting structure folders the export works fine and ends up inside of the deployment folder. When I try to do the entire content store, it fails and it fails with or without user accounts included.

Is there a better way to migrate this cognos instance, user info and reports to a fresh cognos 10.2.2 install? That's the goal here.

22
Administration and Security / Re: Cognos Analytics 11.0.13
« Last post by ukflix on 18 Oct 2018 08:49:27 am »
Thanks MFGF, that helps quite a lot.
23
Report Studio / Re: add or substract measures in a crosstab
« Last post by sergiord2016 on 18 Oct 2018 08:35:23 am »
Thank you very much.

It works!!!!!
24
Upgrading to Cognos Analytics / Cognos 11 Timestamp issue
« Last post by highwingers on 18 Oct 2018 08:23:05 am »
Hey anyone have a fix for this error I'm getting in my DQM report in Cognos 11
An unexpected exception occurred:
com.cognos.xqe.runtree.relational.vectorization.TimestampColumnVector incompatible with com.cognos.xqe.runtree.relational.vectorization.LongColumnVector
25
COGNOS Planning / Re: Have to make multiple connections to ODBC
« Last post by sdf on 18 Oct 2018 07:33:08 am »
You might want to check your Cognos Planning Data source connection. Check if you created a signon that everyone group can use. Else it will need to authenticate the user for each session.
26
Administration and Security / Re: Cognos Analytics 11.0.13
« Last post by MFGF on 18 Oct 2018 06:54:29 am »
Just wondered if anyone had any inside knowledge as to when 11.0.13 will be released please?

Thanks

I was at an IBM event this week in London, and one of the presenters mentioned it would probably be December, but it still might change. I guess this means the official answer is "wait and see" :)

Cheers!

MF.
27
COGNOS Planning / Have to make multiple connections to ODBC
« Last post by KeithHartley on 18 Oct 2018 06:28:33 am »
On my dev/test system (10.2.2? - Install 10.2.200.32 EN  Build EPANALYST 10.2.200.16) when I open a D-Link which contains a SQL query I am asked for user id and password and the system connects (I know this because I get a message regarding changing to US English), so far so reasonable. However before the D-Link appears I have to repeat the user id password combination and then if I wish to run the update I get asked again!

My current live system asks for the user id and password once for a session.

Any ideas why Analyst doesn't hold onto the connection?
28
Administration and Security / Cognos Analytics 11.0.13
« Last post by ukflix on 18 Oct 2018 06:09:41 am »
Just wondered if anyone had any inside knowledge as to when 11.0.13 will be released please?

Thanks
29
Report Studio / Re: add or substract measures in a crosstab
« Last post by MFGF on 18 Oct 2018 05:21:55 am »
We actually have both models created , dimensional or relational.

In this casi the measure and the dimension are draggeg from dimensional model , but if relational solution is better we can use relational model.

Before now i have been always used teh dimensional modeling because i have to make always the comparison between one year and the previous year.

I only know how to do this comparison dragging the members that correspond to one year and previous year.

Now i have the problem that this report is not static , has a user filter so the static member can't be used , i have probed with data element calculating one year and previous year and using them as dimensions but it does not work.

Hope this will help in your answer. Thanks in advance.

Hi,

If you have a dimensional package, this is pretty easy.

First, remove your detail filter - these are a relational concept and could easily deliver incorrect results with a dimensional package.
Next, remove the Year level from your crosstab row headings.
Drag a new query calculation into the rows area of your crosstab, and use a dimensional expression to prompt for the year you want to see, using an expression of:
<your Year level> -> ?Your Year Parameter?
Next drag a second query calculation below the existing calculation in the row headings. Use a dimensional expression to return the previous year:
prevMember(<your Year calc from above>)
You can now add a third calculation that subtracts one from the other.

Cheers!

MF.
30
Report Studio / Re: add or substract measures in a crosstab
« Last post by sergiord2016 on 18 Oct 2018 05:11:36 am »
We actually have both models created , dimensional or relational.

In this case the measure and the dimension are draggeg from dimensional model , but if relational solution is better we can use relational model.

Before now i have been always used teh dimensional modeling because i have to make always the comparison between one year and the previous year.

I only know how to do this comparison dragging the members that correspond to one year and previous year.

Now i have the problem that this report is not static , has a user filter so the static member can't be used , i have probed with data element calculating one year and previous year and using them as dimensions but it does not work.

Hope this will help in your answer. Thanks in advance.
Pages: 1 2 [3] 4 5 ... 10

       
Twittear