Recent content by raju111

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...

For first method .... My understanding is first import all three tables F1,D1,D2 In database layer just join D1 and D2 and in model layer join F1 query subject with consolidated (D1&D2) query subject ?? Please confirm Thanks again...

Thanks for your valuable advise , can you please elobarate little more about "use an alias on D2 to join to the fact " Thanks in advance... First one will work for me but i would like to know about second case ...

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

Thanks for reply, haning the powerplay screen means junt not doing any thing, and if i see the task manager the application is not responding.You sugested insted of powerplay report writer,what is that?plz tell me more about report writer. Thanks, Noothan

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

Thanks for your reply sir,When i open the report its just hanging with blank white screen.No error message came. 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...