Recent Posts

Pages: [1] 2 3 ... 10
1
Framework Manager / Re: Joins in Database or Logical layer?
« Last post by MFGF on Today at 07:41:22 am »
I don't see the point of 2 layers for that (Logical and Business) when relations are already in the database layer.

What is left to the business layer in this case?

I don't follow? I'd have a database layer, and a logical/business layer. The database layer has the relationships. The logical/business layer has the calcs, filters, friendly names, friendly structures.

MF.
2
Never mind, it was some sleepiness from my side doing the relationships on a wrong field... Please delete this post of shame!  :-[

There's no need for shame. You should see some of the gaffes I made over the years! :)

MF.
3
Reporting / Re: We can't get your schedule right now. Try again later.
« Last post by zakatak on Today at 07:37:39 am »
I had the user recreate the schedules. I do not know what the cause was.
4
Active Reports / Re: File size reduction approach in Active Reports
« Last post by Lynn on Today at 07:16:28 am »
Hi All,

I want to reduce the file size of my dashboard from 46 MB to 20 MB or less. Please suggest any approach.

Regards,
Nancy

The active report cookbook has some suggestions in this regard. Take a look at the section called Guidelines to Building an IBM Active Report:
https://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html

Do you have a lot of charts on decks? If so, you might find a big improvement by replacing them with visualizations.
5
Framework Manager / Re: Joins in Database or Logical layer?
« Last post by Invisi on Today at 06:39:38 am »
I don't see the point of 2 layers for that (Logical and Business) when relations are already in the database layer.

What is left to the business layer in this case?
6
Never mind, it was some sleepiness from my side doing the relationships on a wrong field... Please delete this post of shame!  :-[
7
Active Reports / File size reduction approach in Active Reports
« Last post by nancysinghal on Today at 06:31:51 am »
Hi All,

I want to reduce the file size of my dashboard from 46 MB to 20 MB or less. Please suggest any approach.

Regards,
Nancy
8
Framework Manager / Re: Joins in Database or Logical layer?
« Last post by MFGF on Today at 04:53:39 am »
So what's the use of the logical layer then?

It's used to add calculations and filters, to re-arrange structures to make things more intuitive, to change names to be more friendly etc.

MF.
9
Report Studio / Re: SQL query into Cognos report
« Last post by Invisi on Today at 04:50:16 am »
Consider you can speak from the desired result, not from how you retrieve the data to get to your result. Are you going to show data in a list, or is it for a graph of some sort?
10
Perhaps you mean before or after the aggregation result? This is a parameter you can set for the filter. By default the filter is applied before aggregation, so like a regular where. So if you want to have the filter work on your result (after aggregation), you must change the parameter.
Pages: [1] 2 3 ... 10

       
Twittear