Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: If -then- else statement error
« Last post by cognos4321 on Today at 12:45:16 pm »
Thanks for the reply , Kiran.

Nesting didn't work too.

So, here's what I did.

1) As mentioned earlier the below mentioned statement gives correct result
If(?pVersion? = 'budget') then ( [abc]=1)
else ([def] =1)


2) Used the year parameter alone which is causing issue
If(?pYear? = '2017') then ( [abc]=1)
else ([def] =1)

This gives me data only for the 'else' filter( [def] =1) and skips [abc]=1 on its own.

Tried working around with cast function thinking it could be something related to the data types but no luck.

Any help is appreciated.
Thanks
 



2
Dynamic Cubes / Need Suggestion on Dynamic Cubes
« Last post by richiearora on Today at 09:24:50 am »
Guys Looking for a Suggestion:

This is first time i want to Leverage building an Ad Hoc Solution for a Client and have Decided will use Dynamic Cubes .

Here is My Question:  We have 2 Facts and 10 Dimensions ( Large Dimensions).

Each fact is Start schema in itself with 10 Dimensions . Just as an Information 8/10 Dimensions are Shared Dimensions between Facts . 2 Dimensions doesnt imply to both facts.

So How should i approach this?

1) Do 2 Separate Dynamic Cubes for each fact ?
2) Not sure is this a Possibility, But can i do 1 Cube and Virtually bring in 2 Cubes with respective Facts and Dimensions?
3) Another questions i have is, I have a fact which is a Join between 2 facts - Like Line and Detail Fact and then combinations Keys Joins to other 9 Dimensions. How do i go about doing this? is this to be handled in Framework Manager and make a Star Grouping Schema and use this package to build a dynamic cube?
4) Is there a Limitation on Dynamic cube to use 2/3 Facts in each Dynamic cube model?

Thanks,
Richie

3
TM1 / Re: "Goto" type functionality in TI process ?
« Last post by donap on Today at 08:17:44 am »
Thank you.


Never thought to do that -- but that makes so much sense. 
4
SDK / Get Location of an Object (path of directory)
« Last post by H_W_Lewis on Today at 08:08:37 am »
Hi,
I am searching for a fast method to get the location of any arbitrary object / entry in the content store.

Background:
Our LDAP Namespace is encrypted, i.e. the CAMID within Cognos looks something like:
"CAMID("prod01.myserver.de:u:966a678f2dc1954da95f6ce04c230799")"
The actual location of the user account that I want to extract could be, for example:
Directory > LDAP > People > Employees > Region A > Department C >

So it is impossible to reconstruct the location path from the CAMID / searchPath.

I was succesful with using the  .getParent() method recursively, but this is not very effective. The method needs to be called many times, since it only returns the direct parent.

In Cognos Connection, when you click on "Set Properties -> General" you can see the location path as well for any object. I'd like to know how to best extract that little bit of information.

Any help is appreciated. Thanks
5
I am considering taking the IBM course "IBM Cognos Framework Manager Design Metadata Models (V10.2.2) - SPVC (Code J2A52G)" in order to take the the cert test for "C2090-632 - IBM Cognos 10 BI Metadata Model Developer".

However, my company is moving to Cognos Analytics (aka 11) early next year. So I have a few questions.

1. Is FM still used in CA as the primary tool for modeling?
2. Will what I learn in the above course translate well to CA and FM 11?
3. Do you feel it's worth waiting for a v11 course and test?.. and how long does IBM usually take to update their courses and tests?

Thanks in advance for your response!

Hi,

Yes, CA is still the primary modelling tool in CA. A new browser-based modelling UI has also been added (Data Modules) but these are much simpler than FM models and are not suitable for multi-fact multi-grain scenarios (unlike FM, which does all this and more).

FM is virtually unchanged between Cognos 10.2.2 and Cognos Analytics, so what you learn on the 10.2.2 course will still be relevant and current.

I don't really see a good reason to wait for a v11 certification in this case, since the UI and concepts in FM 10 vs FM 11 are exactly the same.

Cheers!

MF.
6
Report Studio / Re: Crosstab in dimentionnal reporting
« Last post by MFGF on Today at 05:05:42 am »
The 2 members are stacked vertically. It is strange because I get no data. could you see what is the problem?

Hi,

No - this ought to work just fine. Can you replicate what you are seeing using one of the sample packages?

MF.
7
Creating a Connection between Maps and Visualization for Active Reports in cognos 11?

I have a Requirement where i need to connect between maps and visualization,but it is showing and error. Please find the error below.

Cannot read property 'adapterid' of undefined.

Thanks in Advance.

Hi,

Can you tell us exactly what you did in your report? The error message you posted could mean anything, and it's impossible to know where the issue might be unless you describe exactly how you set things up...

Cheers!

MF.
8
Reporting / Re: Understanding error message
« Last post by prikala on Today at 12:28:27 am »
How about a parameter map based on query items?

If [QUserIDBridge].[Level03_Security] is something filtered by userid,
you could define the paremeter map in the FM having userid as key
and Level03_Security as value.
Then in the report you could use something like this:
   # map_Level03_Security{$account.personalInfo.userName} #
to get the parameter to compare to.
9
Reporting / Re: Tabbed report
« Last post by Drisya on Today at 12:01:32 am »
Got it. Thanks  Lynn :)
10
Creating a Connection between Maps and Visualization for Active Reports in cognos 11?

I have a Requirement where i need to connect between maps and visualization,but it is showing and error. Please find the error below.

Cannot read property 'adapterid' of undefined.

Thanks in Advance.
Pages: [1] 2 3 ... 10

       
Twittear