COGNOiSe.com - The IBM Cognos Community

Hi All,

Different Distributors have access to the cognos.

My dimension has levels like Region,Distributor,Reps and so on.

So say I have a simple list report to be bursted to different distributors.

My list will have a Distributor level and Revenue value.

Now I create an external source table either in excel or sql server with two columns, one is camid of these distributors and their email ids and bring in to cognos.

Is there any automated process to get the cam ids of the distributors .

Is cam id mandatory here .how will this relate to my data item..

Can I have this instead of my distributor data in the source table

Now my question is
If I want to sent the burst reports via email , then what should I bring in from my external source.

A table with email id and Cam id or table with email id and distributor data item.

Thanks,
Nithya

table is email and distributor data item. make sure it joins properly and you are good to go

Hi ,
How do I join this relational table with the existing olap cube .
My package now has a relational table with burst information and a olap cube.

I was not able to compare this burst data with my olap data field with caption() function.

How should I achieve this.

Thanks,
Nithya

this information is too important to have been left out don't you think?;D   *huh  :o de ja vu  :o*

Quote from: nithya1224 on 17 Sep 2014 08:46:13 AM
How do I join this relational table with the existing olap cube .
My package now has a relational table with burst information and a olap cube.

create two queries in report studio and join them. if the query from OLAP retains the dimensionality, try to use caption function. you might want to read this:

http://cognosm.fm3online.com/dimensional/stripping-dimensionality-of-a-member/

*chuckle

Quotethis information is too important to have been left out don't you think?;D   *huh  :ode ja vu  :o*

Hi All,

I am getting this error while doing a join

Initially, in data source type(s) '', the function 'realDataMode' is not supported in 'NoDataModeProvider'. After decomposition, in data source type(s) '', the function 'subQuery' is not supported in 'TabularFuncProvider'


Query 1 : Relational data source with two columns  DistributorName and EmailID
Query 2: Olap cube with data from one dimension: DistributorNameLevel and Qty

Join Query1 and Query2 on DistributorName  and  caption(DistributorNameLevel)

Add a list copy all the items to Query3 (join query) and run the report with three columns DistributorNameLevel,EmailID and Qty

Please advice what should I do , I am able to create  a master detail relationship between two queries, but join is not working.

Thanks,
Nithya

Hi All,

I did a master detail relation ship between the relational source and the dimensional source.

I had two columns in relational with Distributor Name and Email.

And my crosstab has distributor name and other columns in it.

My master query is relational source data in a list with two columns and my crosstab is nested as the third column in the list.Master detail relationship defined between two queries. If i run the report I get the data, but on validating or bursting the report I get the error :
"RSV-VAL-0016 The burst query Query2(used in crosstab) cannot be a nested query. "

I read some post and tried setting my query property in my page to master query, but it still throws the error.

Please let me know your suggestions.

Thanks,
Nithya

*sigh* :-\