Recent Posts

Pages: [1] 2 3 ... 10
1
Administration and Security / Number of retrieved rows exceeds
« Last post by halciber on Today at 03:05:55 pm »
Hello,

I've got a user who is reporting getting an error on 3 reports. The error is "The number of rows retrieved for the user....exceeds the limit of 5000." This confusing because she doesn't appear to have any account limits. A user from the same group has no problem running this report. He appears to have the same rights and privileges as she does. I've compared report settings and user rights, but I don't see anything that suggests that she should have any retrieval limits.

This is on Cognos 11. What can I look at that might help me solve this problem?

Thanks,
Mike Goldweber
2
Reporting / Re: Distinct first name and last name
« Last post by Cognos_Jan2017 on Today at 02:39:07 pm »
Can you drag in a Repeater, and assign concatenation (First/ Last Names, and forward slash) something like ...
[FirstName]+' / ' + [LastName]+' / '

Your "actual data is only in the first column." could be your Repeater, knowing the "other 2 columns" are blank.
What if you DON'T merge those 3 columns, but just Render the "actual data column"?
3
Framework Manager / FM11 setup
« Last post by sdf on Today at 02:14:48 pm »
Hi,

Is it possible to configure an FM setup to use AD as authentication rather than the default authentication used in cognos connection?


We have a gateway as well, but the gateway was configured to use the default authentication.
I'm looking as well a way to include camnamespace in the gateway uri, maybe this can be a work around.

Let me know what you think.
4
Dynamic Cubes / Can Dynamic Cube be used in Tableau?
« Last post by cognostechie on Today at 02:04:53 pm »
Hi All -

I created only one dynamic cube so far and that was more than an year ago so couldn't do this research myself.

Since the dimensions and facts are stored in tables in a database and since Tableau can use a database as a source, does anyone know if a Dynamic Cube can be used in Tableau to make a Dashboard? Anyone tried it?

Thanks
5
Reporting / Re: Distinct first name and last name
« Last post by rwaugh on Today at 02:01:23 pm »
For the "extra" repeater columns, try leaving them in your List Design, but select the "List Column" property of any column(s)
NOT to be exported into Excel, and set its(their) Render to No.

HTH, Bob

Thanks Bob!  The issue is that the columns that are showing in Excel aren't actually showing in the list design.  In my design I have just the one column for First Name and one for Last Name.  When it comes out in Excel the heading for the column is 3 columns (merged) but the actual data is only in the first column.  The other 2 columns are blank.  All the research I have done up to this point is telling me that there is no fix for this...I'm hoping everyone is wrong though lol
6
My apologies. My questions is,

Just talking about Cars Sold, I'm trying to stay with one Query and not two but have two columns for years (2018 and 2017) in the Crosstab.
So, basically, when I create two different Data Items using the below code, I get zero on the 2017 going back one year.

For: 2017:
 
Case
when ([Car Sold Date] <= _add_days(?Prompt Date?,-365) then
([Car Total Count])
else
(0)
end

Ignore the Cards junked for now. Sure, I understand one year may not be 365.

Thanks so much@


7
Your post does not have enough information to analyse the problem.

The [Car Total Count] is supposed to be for Cars sold or cars sent to junkyard? -365 does not necessarily mean last year.
If the date of the transaction does not fall into your calculation then it will produce 0 so that's ok which might be the reason yuo are seeing 0.

If you want a report like your screenshot shows, then you could simply create two queries, one for Cars Sold and another for Cars sent to junkyard (presuming they are from two data sources) and then union them to produce the output.
 
8
Report Studio / Re: SQL and floating point
« Last post by cognostechie on Today at 11:49:14 am »
If it is easy to post the SQL that works, why is it difficult to post the SQL that does not work? Why expect everyone to wreck their brains trying to figure out why you are doing wrong in your query? Having a visual of the problem makes it much easier to understand rather than having an imagination of the problem.
9
Hi, sorry to trouble you guys again. :) :)

I'm using Singleton to populate some of the data in this table. The data is coming from different sources so I'm trying to have two different Queries.
One to populate the total cars sold for FY 2018 and the previous year and another Query for Total Cars sent to Junk Yard for 2018 and the previous year.

This way, I can drop the Data Items to the Singleton that looks like the attached mockup.

When I try a Case statement such as below, I get '0'.  The [Car Total Count] is a Measure. 
Data Item: Going back one year.

Case
when ([Car Sold Date] <= _add_days(?Prompt Date?,-365) then
([Car Total Count])
else
(0)
end

Any ideas what's causing it to drop a "0"
10
Reporting / Re: Distinct first name and last name
« Last post by Cognos_Jan2017 on Today at 10:56:18 am »
Quote
My new issue is now ensuring that the "repeater" columns are exported into excel as one column each instead of multiple columns (Not a huge deal as I can simple delete the extra columns that are blank, but it just looks ugly initially).

For the "extra" repeater columns, try leaving them in your List Design, but select the "List Column" property of any column(s)
NOT to be exported into Excel, and set its(their) Render to No.

HTH, Bob
Pages: [1] 2 3 ... 10

       
Twittear