Search results for query: *

just copy data item from another query subject and poll to corsstab . or u can use nested crosstab . Anda

Hi , friend . try this: 1. set date prompt ,parameter name as“PDateTime“: Default Selections : Jan 1, 2009 12:00 AM 2?in Query add filter?and set as Optional? case when ?PDateTime? = '2009-01-01 00:00:00.000' then ([Sales (query)].[Time dimension].[Date] > _add_days(current_date,-1)) else...

if u use powerplay transformer , u can get week from create a new dimension ; if u use framework manger , u can use week function to get week value. Anda

ur attached files cant't open, would u paste them again. thanks Anda

you can try the conditional variable and using row_count to do that Anda

you can just import the table as Query Subject in the FM model , then under Externalize Method just choice "IQD". when you publish this query subject select store in local. then you can use the export IQD in transformer. after that if u want to modify you can just use notepad open it.

you can still use your current cognos 8.2, but need to re-configure the content store.

after you build the vaule prompt, click the Value Prompt object and check the Properties: General\Default Selections. with the input value, you should check the properties of the value you want to focus on. Remember check the value of "Member Unique Name" Ex...

you could disable or modify the property in Access Manager Console

in the menu Data->Drill Behavior..., select "Allow drill-up and drill-down " check box, and also select the following check box if u don't want to use the drill up/down fun. Anda

maybe u can try event studio.

maybe u use the same query item

if you want to show the report for last 13 months. I think you should setup the running-total time not prompt time.

for my personal suggest , you should re-create reports in cognos 8 will be better

i the tool meun there is a "Build Prompt Page", this fun. can simple help u to build a prompt Anda

u can set the "Rows per pages" in the Data properties

it looks like when u save in html mode it will not work for prompt again ~