Search results for query: *

I have developed a report in report studio which uses 4 promots . After selecting 4 values for prompts and hit run button in this case we are having performance issues. Is there a way to apply first prompt and run query(first result set will filter out half of the records) and apply second...

I have a Fact 1 joining to Dim1 Dim1 is joining to D2 ( one to many ) many is D2 side Dim2 is joing to Dim3 table (many to one) many is D2 side. basically D2 is a bridge table between D1 and D3 How to model these tables , any suggestions ?? where to create determinants ? thanks in advance

Hello Friends , I have a question on framework manger model I have below tables 3 dims , 2 facts Dim1-->Dim3 Dim2-->Dim3 Same Dim3 -->Fact1 Dim3-->Fact2 Snowflake Schema , Dim3 is Slowly changing type 0 how to handle this type of situvation ?? thanks in advance

Friends , I have model design related question . Your help/comments greatly apriciated I have below tables F is fact , DIM is dimension tables. Join sequence F1 --> DIM1 -->DIM2--->DIM3 Another join sequence F1 -->DIM4-->DIM5-->DIM6--DIM7 There is a join between DIM1-->DIM7 How to model...

Hello friends, I have one fact table f1 and two dimension tables d1 , d2 . I have below joins F1 joins with D1 D1 joins with D2 There is no join between F1 and D2 .How to model these tables in framework manger ?? Any ideas will be appriciated ... thanks in advance

Hi, I have a Powerplay report which contains millions of rows.I am trying to supress zeros in rows (Exp mode).But its hanging and not doing any thing.Plz help me. Thanks, Noothan

Hi, I have Impromptu reports which are created in EP series , now i am unable to open the report.If i open it just blank white screen is appearing and no fish is running.No error message simply hanging.Help me in opening the reports. Thanks, Noothan

Hi, I want to call a control file(.txt) which has data base name,userid,password,dbq info from a macro.Plz help me what code i have to write in a macro to call control file.It has to open a control file and take the all information and close. Thanks, Noothan

Hi, Id it possible to call a control file(.txt) from a cognos macro.If yes plz provide the code.I would like to put Database connetcing string,username , password info in control file. Thanks, Noothan

I am trying to create a powerplay report(ppr file) from cube(mdc file) on server.While draging and droping dimensions and measures it is saying out of memory.The application is not responding.Then i am killing the session.Plz help me in this issue.Cube size is 8 mb. I am working on win-NT with...

I am trying to create a powerplay report(ppr file) from cube(mdc file) on server.While draging and droping dimensions and measures it is saying out of memory.The application is not responding.Then i am killing the session.Plz help me in this issue.Cube size is 8 mb. I am working on win-NT with...

Hi, I am trying to create a powerplay report(ppr file) from cube(mdc file) on server.While draging and droping dimensions and measures it is saying out of memory.The application is not responding.Then i am killing the session.Plz help me in this issue.Cube size is 8 mb. Thanks Noothan

Hi, I have a mdc file(Cube). Am trying to create a powerplay report from (PPR file from cube).While applying supress zeros in rows and colmns option it is just not responding.I conformed that in File--> preferences--> supress -->zero values check box was checked.I have about 160000 rows in my...

We have a 50 Powerplay Reports and i Wrote macros to load data from Powerplay reports to other Oracle tables. Now i need to refresh the oracle tables with these macros from powerplay reports on daily basis.For this i need to run batch scripts in a scheduler (on NT box) . Can any body send me the...

Hi, In the cube(mdc file) not giving the sum of rows.I had taken regular rollup as default(sum),time state rollup as current period,duplicate roll up as None(Regular rollup) in the model.Plz suggest me . raju