Applied dimensionality

and what’s name of this file? I had this problem to.

reread first line, den )

Hi Yuri,

Sorry for posting this question here.
Can we use dimensional functions (like currentMember) on DMR (cognos83+Oracle)

And i’m really sorry for posting this here, i know it is irrelevant to the post, but i didn’t know how to reach you!

Thanks.

Hi Madhu,

Yes, you can use dimensional functions — that’s all what DMR is for (except for magnificient Analysis Studio) ). DMRs automatically translate all PeriodsToDate, Current\PreviousMember to valid SQL queries.

And no problem, post questions anywhere or mail me at mail@ykud.com )

Thanks,, Thank you very much

But, my code piece keeps throwing me an error saying that,
“olap_currentmember” is not supported by “RelationalQueryProvider”

My code for calculated measure goes like this:
CASE currentMember()
WHEN THEN
WHEN THEN
ELSE
END

Is there anything wrong with this?

And i want to use this calculated measure in Analysis Studio.

Do you think, I have to go PowerCube?

And thanks again for your time!

Madhu
cognosmadhu@gmail.com

Your problem is in case clause — you cannot have case clause on CurrentMember in measure. Instead of using case, you should use aggregations over filtered sets. Like
total(measure within set(filter([your_dimension], your_when_clause))
If you can give more detail on what you’re trying to achieve, i can try to write better example

Hi, Is it possible to publish create a package in MSSQL and publish in oracle.

Hi, Sreedhar.
Can you reformulate your question — it’s pretty dim in current variant?
Package in Cognos is a compiled subset of metadata definitions avalaible for users. For example, you have a fully blown DWH model and you “show” only sales part to interested people to avoid confusion and complexity. Publishing is a process that compiles metadata and puts it into BI portal (content store database, to be clear)