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...
Ah, Mr Blom, read a lot of your posts.
Yes, the composite dimension idea came to me last night but its good to hear it from some one else. What has happened today is that the ProductWarehouse has become a fact as I now have a measure that is at that grain (stock in transit). That being the...
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...
Still can't do this but have developed a work-around. Set up an attribute, Leaf Level, in the source dimension. Create data item with filter() and select on the attribute:
filter(
[Cube].[Dimension].[Hierarchy],
[Cube].[Dimension].[Hierarchy].[Leaf Level] = 'Y')
Think getting leaf members...
No takers? I've scoured the Cognos user guide and there are warnings about unpredictable ragged hierarchy behaviour but nothing about how to work with them. I get the impression that in the ReportStudio view of the world it would be better if ragged hierarchies didn't exist - but they do and...
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...
Hi John,
Thanks for the reply, I've been away for a while so sorry about the delay in getting back to you.
You've come up with pretty much with my preferred solution which is to separate the dimensional aspects from the structural. In my mind the dimension table is the bridge table. A...
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...
Just FYI from Transformer 8.4 you can publish a cube as a package in Cognos Connection directly without having to use FM. Just right click on cube and select 'Publish PowerCube as Data Source and Package' - understand that this isn't a lot of help if you're on 8.1 but one for the future eh?
This structure is not going to work in any tool.
1) You've got items being their own parent e.g. orgunitkey 6 has orgunit name of ORG A and a parent of ORG A.
2) Each Org unit has multiple parents and each parent has multiple children i.e. a many-to-many relationship - not a hierarchy...
The other way to do this is to have a table of dates (like a date dimension table) and have a flag column to indicate whether the day is a workday or not, something like:
cal_date dow_name is_work_day
--------- ------------- ------------
1/01/2008 Tuesday N
2/01/2008 Wednesday Y
3/01/2008...
Paul,
Thanks again for taking the time to respond. I'm still confused (or just a bit slow!)
I understand the structure you're suggesting, each product grp has one-and-only-one skey. In your example you used:
Product_SK Product_Name ProductGrp_SK ProductGrp_Name
----------...
Firstly, thanks for the responses, very encouraging.
I have a problem with MDXer's solution.
You say: 'My approach would be to use a group SK that is unique to the group level. In fact this is standard practice for me, ensuring that members at each level are distinct.'
I don't see how the...
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 Jean,
No need for the SDK, I’ve found that there is an alternative form of burst key that explicitly names the user/user class. For example if the user class in AccessManager is called ‘Project1746’ then the burst key for that user class is given by...
Hi Jean and thanks for the post but as I mentioned in my original post we don't have the SDK. I'm really looking for a non-SDK solution but I'm begining to think that this may not be possible. Any other thoughts?
Cheers, Tom
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...
xs4citrix and avitabj
Thanks for your input. I've now discovered that the DS configuration is saved away in a series of LDIF files that are flat ASCII. I've looked at the main one in Notepad and found that it is completely blank, 109K of whitespace! I overwrote this file with the...
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...
I see this thread has been going for a while now and I'd like to throw in my 2c worth. Personally I loath the Cognos certification >:-<. These kind of exams suit some people and not others - I'm in the latter camp having a serious mental block with all exams not just Cognos. I'm not stupid...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.