Search results for query: *

Hi, I'm just finishing off the modelling of a classic Sales Orders fact and have pushed all of the header information down to the line level as I believe is best practice. I've also got the Order number as a degenerate dimension but there are attributes that really are attributes of the header...

Hi, I have a fact table with 5 dimensions. Two of them are product and warehouse. There are textual attributes of the product / warehouse combination Clearly these can't be held in either of the two dimension tables I have created a ProductWarehouse table to hold the attributes. Not sure what...

Away from ReportStudio for a number of years so a bit rusty. Thought this should be simple but can't see how to do it. Can't see an answer posted. How do I create a set of all the leaf members of a ragged hierarchy? Don't think I can use descendents() as there isn't a named level or a fixed...

A bit of a tricky design issue that I hope someone can throw some light on We have dimensions with multiple hierarchies. All hierarchies are set up as level 1 - level 15. In the source data the different hierarchies for a single dimension are held in one table. The hierarchies are...

Hi I'm sure this is something that people have come across before and I would imagine that there must be a range of approaches to dealing with it. I've come up with a potential solution so I'm interested in getting some opinions on the idea. I have facts coming in at different grains, in...

Hi, I have been given the job of creating a report that needs to be burst to some 200 UserClasses and I'd like to know if there's a simple way of populating the burst table I need to build. (There is no requirement to burst to email or an external directory) Each UserClass is a project and...

Hi, Part 1 ------- We've recently had an unplanned power outage. When the servers came back up Cognos was not starting and after a bit of digging around I found that the SunOne directory server (DS) we use as our 3rd party authentication source was not starting. I've tried going into the...

Hi, I'm building IQD files from Framework Manager and I've found that it's taking longer and longer for the .IQD files to be written to the file system. The more complex the SQL generated the longer it takes. It appears as if the SQL statements are actually being run rather than just written...

I've just come out of a meeting in which documenting our C8 development so far was discussed and it looks like we're going to be duplicating a lot of information and put it into Word documents with all the usual issues of how do you keep the two in synch. It struck me that the Content Store is...

There may be a standard approach to this as I'm sure I'm not the first to come across the issue. The Problem: We have a date dimension (d_date) with an integer SK, date_sk, starting at 0 and going up to 3650, or thereabouts, for ten years. It also has columns for the date in various...

At the risk of sounding like a right muppet... This has got to be simple but I can't find a solution. I have a type-in prompt (can't use a value prompt for a number of reasons). The user can enter mixed or lower case but we want to display the typed in value in the report header (in a text...

I have a requirement to display text in the cells of of a cross tab. I'm most of the way there but I just can't quite get it to work correctly. The text item I want to display (SalesRepName) is held in a field in the table. When I select a numeric value from the the same table when...

As far as I know the only way to populate a parameter is via a prompt. The interface only allows a single parameter to be specified and populated. I want to populate a number of parameters in one hit, i.e. user select a single value from drop-down, number of parameters populated. The...